/// <summary> /// 增加一条数据 /// </summary> public bool Add(ZhangWei.Model.user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into user("); strSql.Append("User_Id,User_Pwd,Again_Pwd,Bel_Group,Div_Type,User_Auth,Auth_Type,User_Status,Create_User,Create_Date,Create_Time,Appr_User,Appr_Date,Appr_Time,Pwd_Date,Err_Count,Use_eJCIC)"); strSql.Append(" values ("); strSql.Append("@User_Id,@User_Pwd,@Again_Pwd,@Bel_Group,@Div_Type,@User_Auth,@Auth_Type,@User_Status,@Create_User,@Create_Date,@Create_Time,@Appr_User,@Appr_Date,@Appr_Time,@Pwd_Date,@Err_Count,@Use_eJCIC)"); SqlParameter[] parameters = { new SqlParameter("@User_Id", SqlDbType.VarChar, 6), new SqlParameter("@User_Pwd", SqlDbType.VarChar, 8), new SqlParameter("@Again_Pwd", SqlDbType.VarChar, 8), new SqlParameter("@Bel_Group", SqlDbType.VarChar, 3), new SqlParameter("@Div_Type", SqlDbType.VarChar, 1), new SqlParameter("@User_Auth", SqlDbType.VarChar, 1), new SqlParameter("@Auth_Type", SqlDbType.VarChar, 1), new SqlParameter("@User_Status", SqlDbType.VarChar, 1), new SqlParameter("@Create_User", SqlDbType.VarChar, 6), new SqlParameter("@Create_Date", SqlDbType.VarChar, 7), new SqlParameter("@Create_Time", SqlDbType.VarChar, 6), new SqlParameter("@Appr_User", SqlDbType.VarChar, 6), new SqlParameter("@Appr_Date", SqlDbType.VarChar, 7), new SqlParameter("@Appr_Time", SqlDbType.VarChar, 6), new SqlParameter("@Pwd_Date", SqlDbType.VarChar, 7), new SqlParameter("@Err_Count", SqlDbType.Float, 8), new SqlParameter("@Use_eJCIC", SqlDbType.VarChar, 1) }; parameters[0].Value = model.User_Id; parameters[1].Value = model.User_Pwd; parameters[2].Value = model.Again_Pwd; parameters[3].Value = model.Bel_Group; parameters[4].Value = model.Div_Type; parameters[5].Value = model.User_Auth; parameters[6].Value = model.Auth_Type; parameters[7].Value = model.User_Status; parameters[8].Value = model.Create_User; parameters[9].Value = model.Create_Date; parameters[10].Value = model.Create_Time; parameters[11].Value = model.Appr_User; parameters[12].Value = model.Appr_Date; parameters[13].Value = model.Appr_Time; parameters[14].Value = model.Pwd_Date; parameters[15].Value = model.Err_Count; parameters[16].Value = model.Use_eJCIC; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo() { ZhangWei.BLL.user bll = new ZhangWei.BLL.user(); ZhangWei.Model.user model = bll.GetModel(); this.txtUser_Id.Text = model.User_Id; this.txtUser_Pwd.Text = model.User_Pwd; this.txtAgain_Pwd.Text = model.Again_Pwd; this.txtBel_Group.Text = model.Bel_Group; this.txtDiv_Type.Text = model.Div_Type; this.txtUser_Auth.Text = model.User_Auth; this.txtAuth_Type.Text = model.Auth_Type; this.txtUser_Status.Text = model.User_Status; this.txtCreate_User.Text = model.Create_User; this.txtCreate_Date.Text = model.Create_Date; this.txtCreate_Time.Text = model.Create_Time; this.txtAppr_User.Text = model.Appr_User; this.txtAppr_Date.Text = model.Appr_Date; this.txtAppr_Time.Text = model.Appr_Time; this.txtPwd_Date.Text = model.Pwd_Date; this.txtErr_Count.Text = model.Err_Count.ToString(); this.txtUse_eJCIC.Text = model.Use_eJCIC; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ZhangWei.Model.user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update user set "); strSql.Append("User_Id=@User_Id,"); strSql.Append("User_Pwd=@User_Pwd,"); strSql.Append("Again_Pwd=@Again_Pwd,"); strSql.Append("Bel_Group=@Bel_Group,"); strSql.Append("Div_Type=@Div_Type,"); strSql.Append("User_Auth=@User_Auth,"); strSql.Append("Auth_Type=@Auth_Type,"); strSql.Append("User_Status=@User_Status,"); strSql.Append("Create_User=@Create_User,"); strSql.Append("Create_Date=@Create_Date,"); strSql.Append("Create_Time=@Create_Time,"); strSql.Append("Appr_User=@Appr_User,"); strSql.Append("Appr_Date=@Appr_Date,"); strSql.Append("Appr_Time=@Appr_Time,"); strSql.Append("Pwd_Date=@Pwd_Date,"); strSql.Append("Err_Count=@Err_Count,"); strSql.Append("Use_eJCIC=@Use_eJCIC"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@User_Id", SqlDbType.VarChar, 6), new SqlParameter("@User_Pwd", SqlDbType.VarChar, 8), new SqlParameter("@Again_Pwd", SqlDbType.VarChar, 8), new SqlParameter("@Bel_Group", SqlDbType.VarChar, 3), new SqlParameter("@Div_Type", SqlDbType.VarChar, 1), new SqlParameter("@User_Auth", SqlDbType.VarChar, 1), new SqlParameter("@Auth_Type", SqlDbType.VarChar, 1), new SqlParameter("@User_Status", SqlDbType.VarChar, 1), new SqlParameter("@Create_User", SqlDbType.VarChar, 6), new SqlParameter("@Create_Date", SqlDbType.VarChar, 7), new SqlParameter("@Create_Time", SqlDbType.VarChar, 6), new SqlParameter("@Appr_User", SqlDbType.VarChar, 6), new SqlParameter("@Appr_Date", SqlDbType.VarChar, 7), new SqlParameter("@Appr_Time", SqlDbType.VarChar, 6), new SqlParameter("@Pwd_Date", SqlDbType.VarChar, 7), new SqlParameter("@Err_Count", SqlDbType.Float, 8), new SqlParameter("@Use_eJCIC", SqlDbType.VarChar, 1) }; parameters[0].Value = model.User_Id; parameters[1].Value = model.User_Pwd; parameters[2].Value = model.Again_Pwd; parameters[3].Value = model.Bel_Group; parameters[4].Value = model.Div_Type; parameters[5].Value = model.User_Auth; parameters[6].Value = model.Auth_Type; parameters[7].Value = model.User_Status; parameters[8].Value = model.Create_User; parameters[9].Value = model.Create_Date; parameters[10].Value = model.Create_Time; parameters[11].Value = model.Appr_User; parameters[12].Value = model.Appr_Date; parameters[13].Value = model.Appr_Time; parameters[14].Value = model.Pwd_Date; parameters[15].Value = model.Err_Count; parameters[16].Value = model.Use_eJCIC; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ZhangWei.Model.user GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 User_Id,User_Pwd,Again_Pwd,Bel_Group,Div_Type,User_Auth,Auth_Type,User_Status,Create_User,Create_Date,Create_Time,Appr_User,Appr_Date,Appr_Time,Pwd_Date,Err_Count,Use_eJCIC from user "); strSql.Append(" where "); SqlParameter[] parameters = { }; ZhangWei.Model.user model = new ZhangWei.Model.user(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["User_Id"] != null && ds.Tables[0].Rows[0]["User_Id"].ToString() != "") { model.User_Id = ds.Tables[0].Rows[0]["User_Id"].ToString(); } if (ds.Tables[0].Rows[0]["User_Pwd"] != null && ds.Tables[0].Rows[0]["User_Pwd"].ToString() != "") { model.User_Pwd = ds.Tables[0].Rows[0]["User_Pwd"].ToString(); } if (ds.Tables[0].Rows[0]["Again_Pwd"] != null && ds.Tables[0].Rows[0]["Again_Pwd"].ToString() != "") { model.Again_Pwd = ds.Tables[0].Rows[0]["Again_Pwd"].ToString(); } if (ds.Tables[0].Rows[0]["Bel_Group"] != null && ds.Tables[0].Rows[0]["Bel_Group"].ToString() != "") { model.Bel_Group = ds.Tables[0].Rows[0]["Bel_Group"].ToString(); } if (ds.Tables[0].Rows[0]["Div_Type"] != null && ds.Tables[0].Rows[0]["Div_Type"].ToString() != "") { model.Div_Type = ds.Tables[0].Rows[0]["Div_Type"].ToString(); } if (ds.Tables[0].Rows[0]["User_Auth"] != null && ds.Tables[0].Rows[0]["User_Auth"].ToString() != "") { model.User_Auth = ds.Tables[0].Rows[0]["User_Auth"].ToString(); } if (ds.Tables[0].Rows[0]["Auth_Type"] != null && ds.Tables[0].Rows[0]["Auth_Type"].ToString() != "") { model.Auth_Type = ds.Tables[0].Rows[0]["Auth_Type"].ToString(); } if (ds.Tables[0].Rows[0]["User_Status"] != null && ds.Tables[0].Rows[0]["User_Status"].ToString() != "") { model.User_Status = ds.Tables[0].Rows[0]["User_Status"].ToString(); } if (ds.Tables[0].Rows[0]["Create_User"] != null && ds.Tables[0].Rows[0]["Create_User"].ToString() != "") { model.Create_User = ds.Tables[0].Rows[0]["Create_User"].ToString(); } if (ds.Tables[0].Rows[0]["Create_Date"] != null && ds.Tables[0].Rows[0]["Create_Date"].ToString() != "") { model.Create_Date = ds.Tables[0].Rows[0]["Create_Date"].ToString(); } if (ds.Tables[0].Rows[0]["Create_Time"] != null && ds.Tables[0].Rows[0]["Create_Time"].ToString() != "") { model.Create_Time = ds.Tables[0].Rows[0]["Create_Time"].ToString(); } if (ds.Tables[0].Rows[0]["Appr_User"] != null && ds.Tables[0].Rows[0]["Appr_User"].ToString() != "") { model.Appr_User = ds.Tables[0].Rows[0]["Appr_User"].ToString(); } if (ds.Tables[0].Rows[0]["Appr_Date"] != null && ds.Tables[0].Rows[0]["Appr_Date"].ToString() != "") { model.Appr_Date = ds.Tables[0].Rows[0]["Appr_Date"].ToString(); } if (ds.Tables[0].Rows[0]["Appr_Time"] != null && ds.Tables[0].Rows[0]["Appr_Time"].ToString() != "") { model.Appr_Time = ds.Tables[0].Rows[0]["Appr_Time"].ToString(); } if (ds.Tables[0].Rows[0]["Pwd_Date"] != null && ds.Tables[0].Rows[0]["Pwd_Date"].ToString() != "") { model.Pwd_Date = ds.Tables[0].Rows[0]["Pwd_Date"].ToString(); } if (ds.Tables[0].Rows[0]["Err_Count"] != null && ds.Tables[0].Rows[0]["Err_Count"].ToString() != "") { model.Err_Count = decimal.Parse(ds.Tables[0].Rows[0]["Err_Count"].ToString()); } if (ds.Tables[0].Rows[0]["Use_eJCIC"] != null && ds.Tables[0].Rows[0]["Use_eJCIC"].ToString() != "") { model.Use_eJCIC = ds.Tables[0].Rows[0]["Use_eJCIC"].ToString(); } return(model); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtUser_Id.Text.Trim().Length == 0) { strErr += "User_Id不能为空!\\n"; } if (this.txtUser_Pwd.Text.Trim().Length == 0) { strErr += "User_Pwd不能为空!\\n"; } if (this.txtAgain_Pwd.Text.Trim().Length == 0) { strErr += "Again_Pwd不能为空!\\n"; } if (this.txtBel_Group.Text.Trim().Length == 0) { strErr += "Bel_Group不能为空!\\n"; } if (this.txtDiv_Type.Text.Trim().Length == 0) { strErr += "Div_Type不能为空!\\n"; } if (this.txtUser_Auth.Text.Trim().Length == 0) { strErr += "User_Auth不能为空!\\n"; } if (this.txtAuth_Type.Text.Trim().Length == 0) { strErr += "Auth_Type不能为空!\\n"; } if (this.txtUser_Status.Text.Trim().Length == 0) { strErr += "User_Status不能为空!\\n"; } if (this.txtCreate_User.Text.Trim().Length == 0) { strErr += "Create_User不能为空!\\n"; } if (this.txtCreate_Date.Text.Trim().Length == 0) { strErr += "Create_Date不能为空!\\n"; } if (this.txtCreate_Time.Text.Trim().Length == 0) { strErr += "Create_Time不能为空!\\n"; } if (this.txtAppr_User.Text.Trim().Length == 0) { strErr += "Appr_User不能为空!\\n"; } if (this.txtAppr_Date.Text.Trim().Length == 0) { strErr += "Appr_Date不能为空!\\n"; } if (this.txtAppr_Time.Text.Trim().Length == 0) { strErr += "Appr_Time不能为空!\\n"; } if (this.txtPwd_Date.Text.Trim().Length == 0) { strErr += "Pwd_Date不能为空!\\n"; } if (!PageValidate.IsDecimal(txtErr_Count.Text)) { strErr += "Err_Count格式错误!\\n"; } if (this.txtUse_eJCIC.Text.Trim().Length == 0) { strErr += "Use_eJCIC不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string User_Id = this.txtUser_Id.Text; string User_Pwd = this.txtUser_Pwd.Text; string Again_Pwd = this.txtAgain_Pwd.Text; string Bel_Group = this.txtBel_Group.Text; string Div_Type = this.txtDiv_Type.Text; string User_Auth = this.txtUser_Auth.Text; string Auth_Type = this.txtAuth_Type.Text; string User_Status = this.txtUser_Status.Text; string Create_User = this.txtCreate_User.Text; string Create_Date = this.txtCreate_Date.Text; string Create_Time = this.txtCreate_Time.Text; string Appr_User = this.txtAppr_User.Text; string Appr_Date = this.txtAppr_Date.Text; string Appr_Time = this.txtAppr_Time.Text; string Pwd_Date = this.txtPwd_Date.Text; decimal Err_Count = decimal.Parse(this.txtErr_Count.Text); string Use_eJCIC = this.txtUse_eJCIC.Text; ZhangWei.Model.user model = new ZhangWei.Model.user(); model.User_Id = User_Id; model.User_Pwd = User_Pwd; model.Again_Pwd = Again_Pwd; model.Bel_Group = Bel_Group; model.Div_Type = Div_Type; model.User_Auth = User_Auth; model.Auth_Type = Auth_Type; model.User_Status = User_Status; model.Create_User = Create_User; model.Create_Date = Create_Date; model.Create_Time = Create_Time; model.Appr_User = Appr_User; model.Appr_Date = Appr_Date; model.Appr_Time = Appr_Time; model.Pwd_Date = Pwd_Date; model.Err_Count = Err_Count; model.Use_eJCIC = Use_eJCIC; ZhangWei.BLL.user bll = new ZhangWei.BLL.user(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }