private void btnAdd_Click(object sender, EventArgs e)
{
//Add();
Dictionary<String, object> getlist = GetValue();
Common.Conn.Connection con = new Connection();
if (isUorA)
{
con.InsertToDataBaseTable(getlist, "UserInfo");
MessageBox.Show("新建成功");
BindDgv();
ControlsIsEnable(true);
ControlsIsEmtring("");
ckIsAllow.Checked = false;
DataTable dt = (DataTable)dgvShowAllInfo.DataSource;
DataRow[] dr = dt.Select("序号=max(序号)");//最大行
int index = 0;
if (dr != null)
{
index = dt.Rows.IndexOf(dr[0]);
}
if (index >= 0)
{
this.dgvShowAllInfo.Rows[index].Selected = true;//选中哪行光标停留哪行
}
}
else
{
con.UpdateToDataBaseTable(getlist, "UserInfo",updateId.ToString ());
MessageBox.Show("修改成功");
BindDgv();
ControlsIsEnable(true);
ControlsIsEmtring("");
ckIsAllow.Checked = false;
int index = GetIndex(updateId);
if (index >= 0)
{
this.dgvShowAllInfo.Rows[index].Selected = true;//选中哪行光标停留哪行
}
btnUpdate.Visible = false;
}
}
public Dictionary<String,object> GetValue()
{
int IsAllow = 0;//1可以登录
Dictionary<String, object> VList = new Dictionary<String, object>();
if (ckIsAllow.Checked)
{
IsAllow = 1;
}
else
{
IsAllow = 0;
}
VList.Add("UserName",txtUserName.Text);
VList.Add("LoginName", txtLoginName.Text);
VList.Add("PassWord", txtPassWord.Text);
VList.Add("HandsetNo", txtHandsetN.Text);
VList.Add("UserInfo_ID", User.UserID);
VList.Add("SetTime", User.getDate()