/// <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");
}
