protected void btnAdd_Click(object sender, EventArgs e)
{
MBusinessTypeData model = new MBusinessTypeData();
MBusinessTypeBB businessTypeBB = new MBusinessTypeBB();
try
{
if (this.State == "1")
{
this.SetModel(ref model);
businessTypeBB.AddRecord(model);
}
else if (this.State == "2")
{
model = businessTypeBB.GetModel(this.IdValue);
this.SetModel(ref model);
businessTypeBB.ModifyRecord(model);
}
}
catch (Exception ex)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",4);", true);
return;
}
finally
{
businessTypeBB.Dispose();
}
}
/// <summary>
/// ����һ������
/// </summary>
/// <param name="model">model</param>
public int AddRecord(MBusinessTypeData model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("set nocount on; ");
strSql.Append("insert into MBusinessType(");
strSql.Append("messageNo,messageNm,tableNm,recordKeyField,keyIsInt,titleField,itemNo,remark,isRun,stopMark)");
strSql.Append(" values (");
strSql.Append("@messageNo,@messageNm,@tableNm,@recordKeyField,@keyIsInt,@titleField,@itemNo,@remark,@isRun,@stopMark)");
strSql.Append("; select @@identity; set nocount off; ");
SqlParameter[] parameters = {
new SqlParameter("@messageNo", SqlDbType.NVarChar,20),
new SqlParameter("@messageNm", SqlDbType.NVarChar,20),
new SqlParameter("@tableNm", SqlDbType.NVarChar,50),
new SqlParameter("@recordKeyField", SqlDbType.NVarChar,50),
new SqlParameter("@keyIsInt", SqlDbType.Bit),
new SqlParameter("@titleField", SqlDbType.NVarChar,50),
new SqlParameter("@itemNo", SqlDbType.NVarChar,20),
new SqlParameter("@remark", SqlDbType.NVarChar,200),
new SqlParameter("@isRun", SqlDbType.Bit),
new SqlParameter("@stopMark", SqlDbType.NVarChar,200)
};
parameters[0].Value = model.messageNo;
parameters[1].Value = model.messageNm;
parameters[2].Value = model.tableNm;
parameters[3].Value = model.recordKeyField;
parameters[4].Value = model.keyIsInt;
parameters[5].Value = model.titleField;
parameters[6].Value = model.itemNo;
parameters[7].Value = model.remark;
parameters[8].Value = model.isRun;
parameters[9].Value = model.stopMark;
int id = 0;
try
{
object ret = SqlHelper.ExecuteScalar(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);
if (ret != null && ret != DBNull.Value)
{
id = Convert.ToInt32(ret);
}
}
catch (Exception ex)
{
throw ex;
}
return id;
}
private void ShowInfo(string id)
{
MBusinessTypeBB businessTypeBB = new MBusinessTypeBB();
MBusinessTypeData model = new MBusinessTypeData();
try
{
model = businessTypeBB.GetModel(id);
this.messageNo.Text = model.messageNo;
this.messageNm.Text = model.messageNm;
this.tableNm.Text = model.tableNm;
this.recordKeyField.Text = model.recordKeyField;
this.keyIsInt.Text = model.keyIsInt.ToString();
this.titleField.Text = model.titleField;
this.itemNo.Text = model.itemNo;
this.remark.Text = model.remark;
this.isRun.Text = model.isRun.ToString();
}
finally
{
businessTypeBB.Dispose();
}
}
private void SetModel(ref MBusinessTypeData model)
{
model.messageNo = this.messageNo.Text;
model.messageNm = this.messageNm.Text;
model.tableNm = this.tableNm.Text;
model.recordKeyField = this.recordKeyField.Text;
model.keyIsInt = this.keyIsInt.Checked;
model.titleField = this.titleField.Text;
model.itemNo = this.itemNo.Text;
model.remark = this.remark.Text;
model.isRun = this.isRun.Checked;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.Params["id"] != null && Request.Params["id"].Trim() != "")
{
this.IdValue = Request.Params["id"];
}
if (Request.Params["state"] != null && Request.Params["state"].Trim() != string.Empty)
{
this.State = Request.Params["state"].ToString();
switch (this.State)
{
case "1": //add
break;
case "2": //update
//���ؿؼ�
MBusinessTypeBB businessTypeBB = new MBusinessTypeBB();
MBusinessTypeData businessTypeData = new MBusinessTypeData();
try
{
businessTypeData = businessTypeBB.GetModel(this.IdValue);
//����й��������˴�Ҫ��֤�Ƿ�������
this.ShowInfo(this.IdValue);
}
finally
{
businessTypeBB.Dispose();
}
break;
default:
break;
}
}
}
this.BindGrid(this.IdValue);
}
/// <summary>
/// ����һ������
/// </summary>
/// <param name="model">model</param>
public bool ModifyRecord(MBusinessTypeData model)
{
return this.businessTypeDB.ModifyRecord(model);
}
/// <summary>
/// ����һ������
/// </summary>
/// <param name="model">model</param>
public int AddRecord(MBusinessTypeData model)
{
return this.businessTypeDB.AddRecord(model);
}
/// <summary>
/// ����һ������
/// </summary>
/// <param name="model">model</param>
public bool ModifyRecord(MBusinessTypeData model)
{
bool ret = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("update MBusinessType set ");
strSql.Append("messageNm=@messageNm,");
strSql.Append("tableNm=@tableNm,");
strSql.Append("recordKeyField=@recordKeyField,");
strSql.Append("keyIsInt=@keyIsInt,");
strSql.Append("titleField=@titleField,");
strSql.Append("itemNo=@itemNo,");
strSql.Append("remark=@remark,");
strSql.Append("isRun=@isRun,");
strSql.Append("stopMark=@stopMark");
strSql.Append(" where messageNo = @messageNo ");
SqlParameter[] parameters = {
new SqlParameter("@messageNo", SqlDbType.NVarChar,20),
new SqlParameter("@messageNm", SqlDbType.NVarChar,20),
new SqlParameter("@tableNm", SqlDbType.NVarChar,50),
new SqlParameter("@recordKeyField", SqlDbType.NVarChar,50),
new SqlParameter("@keyIsInt", SqlDbType.Bit),
new SqlParameter("@titleField", SqlDbType.NVarChar,50),
new SqlParameter("@itemNo", SqlDbType.NVarChar,20),
new SqlParameter("@remark", SqlDbType.NVarChar,200),
new SqlParameter("@isRun", SqlDbType.Bit),
new SqlParameter("@stopMark", SqlDbType.NVarChar,200)
};
parameters[0].Value = model.messageNo;
parameters[1].Value = model.messageNm;
parameters[2].Value = model.tableNm;
parameters[3].Value = model.recordKeyField;
parameters[4].Value = model.keyIsInt;
parameters[5].Value = model.titleField;
parameters[6].Value = model.itemNo;
parameters[7].Value = model.remark;
parameters[8].Value = model.isRun;
parameters[9].Value = model.stopMark;
try
{
SqlHelper.ExecuteNonQuery(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);
ret = true;
}
catch (Exception ex)
{
throw ex;
}
return ret;
}
/// <summary>
/// �õ�һ��model
/// </summary>
/// <param name="messageNo">����ֵ</param>
/// <returns>model</returns>
public MBusinessTypeData GetModel(string messageNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from MBusinessType");
strSql.Append(" where messageNo = @messageNo ");
SqlParameter[] parameters = {
new SqlParameter("@messageNo", SqlDbType.NVarChar,20)
};
parameters[0].Value = messageNo;
MBusinessTypeData model = new MBusinessTypeData();
DataSet ds = SqlHelper.ExecuteDataset(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow row = ds.Tables[0].Rows[0];
if (row["messageNo"] != DBNull.Value)
{
model.messageNo = Convert.ToString(row["messageNo"]);
}
if (row["messageNm"] != DBNull.Value)
{
model.messageNm = Convert.ToString(row["messageNm"]);
}
if (row["tableNm"] != DBNull.Value)
{
model.tableNm = Convert.ToString(row["tableNm"]);
}
if (row["recordKeyField"] != DBNull.Value)
{
model.recordKeyField = Convert.ToString(row["recordKeyField"]);
}
if (row["keyIsInt"] != DBNull.Value)
{
model.keyIsInt = Convert.ToBoolean(row["keyIsInt"]);
}
if (row["titleField"] != DBNull.Value)
{
model.titleField = Convert.ToString(row["titleField"]);
}
if (row["itemNo"] != DBNull.Value)
{
model.itemNo = Convert.ToString(row["itemNo"]);
}
if (row["remark"] != DBNull.Value)
{
model.remark = Convert.ToString(row["remark"]);
}
if (row["isRun"] != DBNull.Value)
{
model.isRun = Convert.ToBoolean(row["isRun"]);
}
if (row["stopMark"] != DBNull.Value)
{
model.stopMark = Convert.ToString(row["stopMark"]);
}
return model;
}
else
{
return null;
}
}
