protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtParamName.Text.Trim().Length == 0)
{
strErr += "参数名称不能为空！\\n";
}
if (this.txtPTypeNum.Text.Trim().Length == 0)
{
strErr += "参数编号不能为空！\\n";
}
if (this.txtPDisplayValue.Text.Trim().Length == 0)
{
strErr += "显示值不能为空！\\n";
}
if (this.txtRemark.Text.Trim().Length == 0)
{
strErr += "Remark不能为空！\\n";
}
if (!PageValidate.IsNumber(txtFlag.Text))
{
strErr += "Flag格式错误！\\n";
}
if (this.txtPTypeValue.Text.Trim().Length == 0)
{
strErr += "PTypeValue不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string ParamName = this.txtParamName.Text;
string PTypeNum = this.txtPTypeNum.Text;
string PDisplayValue = this.txtPDisplayValue.Text;
string Remark = this.txtRemark.Text;
int Flag = int.Parse(this.txtFlag.Text);
string PTypeValue = this.txtPTypeValue.Text;
WebDemo.Model.WebDemo.ParamsKinds model = new WebDemo.Model.WebDemo.ParamsKinds();
model.ParamName = ParamName;
model.PTypeNum = PTypeNum;
model.PDisplayValue = PDisplayValue;
model.Remark = Remark;
model.Flag = Flag;
model.PTypeValue = PTypeValue;
WebDemo.BLL.WebDemo.ParamsKinds bll = new WebDemo.BLL.WebDemo.ParamsKinds();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
private void ShowInfo(int Pid)
{
WebDemo.BLL.WebDemo.ParamsKinds bll = new WebDemo.BLL.WebDemo.ParamsKinds();
WebDemo.Model.WebDemo.ParamsKinds model = bll.GetModel(Pid);
this.lblPid.Text = model.Pid.ToString();
this.lblParamName.Text = model.ParamName;
this.lblPTypeNum.Text = model.PTypeNum;
this.lblPDisplayValue.Text = model.PDisplayValue;
this.lblRemark.Text = model.Remark;
this.lblFlag.Text = model.Flag.ToString();
this.lblPTypeValue.Text = model.PTypeValue;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.ParamsKinds model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ParamsKinds set ");
strSql.Append("PDisplayValue=@PDisplayValue,");
strSql.Append("Remark=@Remark,");
strSql.Append("Flag=@Flag,");
strSql.Append("PTypeValue=@PTypeValue");
strSql.Append(" where Pid=@Pid");
SqlParameter[] parameters =
{
new SqlParameter("@PDisplayValue", SqlDbType.VarChar, 50),
new SqlParameter("@Remark", SqlDbType.VarChar, 50),
new SqlParameter("@Flag", SqlDbType.Int, 4),
new SqlParameter("@PTypeValue", SqlDbType.VarChar, 50),
new SqlParameter("@Pid", SqlDbType.Int, 4),
new SqlParameter("@ParamName", SqlDbType.VarChar, 50),
new SqlParameter("@PTypeNum", SqlDbType.VarChar, 10)
};
parameters[0].Value = model.PDisplayValue;
parameters[1].Value = model.Remark;
parameters[2].Value = model.Flag;
parameters[3].Value = model.PTypeValue;
parameters[4].Value = model.Pid;
parameters[5].Value = model.ParamName;
parameters[6].Value = model.PTypeNum;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebDemo.Model.WebDemo.ParamsKinds model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ParamsKinds(");
strSql.Append("ParamName,PTypeNum,PDisplayValue,Remark,Flag,PTypeValue)");
strSql.Append(" values (");
strSql.Append("@ParamName,@PTypeNum,@PDisplayValue,@Remark,@Flag,@PTypeValue)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ParamName", SqlDbType.VarChar, 50),
new SqlParameter("@PTypeNum", SqlDbType.VarChar, 10),
new SqlParameter("@PDisplayValue", SqlDbType.VarChar, 50),
new SqlParameter("@Remark", SqlDbType.VarChar, 50),
new SqlParameter("@Flag", SqlDbType.Int, 4),
new SqlParameter("@PTypeValue", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ParamName;
parameters[1].Value = model.PTypeNum;
parameters[2].Value = model.PDisplayValue;
parameters[3].Value = model.Remark;
parameters[4].Value = model.Flag;
parameters[5].Value = model.PTypeValue;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.ParamsKinds DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.ParamsKinds model = new WebDemo.Model.WebDemo.ParamsKinds();
if (row != null)
{
if (row["Pid"] != null && row["Pid"].ToString() != "")
{
model.Pid = int.Parse(row["Pid"].ToString());
}
if (row["ParamName"] != null)
{
model.ParamName = row["ParamName"].ToString();
}
if (row["PTypeNum"] != null)
{
model.PTypeNum = row["PTypeNum"].ToString();
}
if (row["PDisplayValue"] != null)
{
model.PDisplayValue = row["PDisplayValue"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["Flag"] != null && row["Flag"].ToString() != "")
{
model.Flag = int.Parse(row["Flag"].ToString());
}
if (row["PTypeValue"] != null)
{
model.PTypeValue = row["PTypeValue"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.ParamsKinds GetModel(int Pid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Pid,ParamName,PTypeNum,PDisplayValue,Remark,Flag,PTypeValue from ParamsKinds ");
strSql.Append(" where Pid=@Pid");
SqlParameter[] parameters =
{
new SqlParameter("@Pid", SqlDbType.Int, 4)
};
parameters[0].Value = Pid;
WebDemo.Model.WebDemo.ParamsKinds model = new WebDemo.Model.WebDemo.ParamsKinds();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
