protected void btnAdd_Click(object sender, EventArgs e)
{
WListData model = new WListData();
WListBB listBB = new WListBB();
try
{
if (this.State == "1")
{
this.SetModel(ref model);
listBB.AddRecord(model);
}
else if (this.State == "2")
{
model = listBB.GetModel(this.IdValue);
this.SetModel(ref model);
listBB.ModifyRecord(model);
}
}
catch (Exception ex)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",4);", true);
return;
}
finally
{
listBB.Dispose();
}
}
/// <summary>
/// ����һ������
/// </summary>
/// <param name="model">model</param>
public int AddRecord(WListData model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("set nocount on; ");
strSql.Append("insert into WList(");
strSql.Append("workflowNo,workflowNm,workTableNm,recordKeyField,keyIsInt,titleField,itemNo,remark,isRun,stopMark)");
strSql.Append(" values (");
strSql.Append("@workflowNo,@workflowNm,@workTableNm,@recordKeyField,@keyIsInt,@titleField,@itemNo,@remark,@isRun,@stopMark)");
strSql.Append("; select @@identity; set nocount off; ");
SqlParameter[] parameters = {
new SqlParameter("@workflowNo", SqlDbType.NVarChar,50),
new SqlParameter("@workflowNm", SqlDbType.NVarChar,50),
new SqlParameter("@workTableNm", 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.workflowNo;
parameters[1].Value = model.workflowNm;
parameters[2].Value = model.workTableNm;
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)
{
WListBB listBB = new WListBB();
WListData model = new WListData();
try
{
model = listBB.GetModel(id);
this.workflowNo.Text = model.workflowNo;
this.workflowNm.Text = model.workflowNm;
this.workTableNm.Text = model.workTableNm;
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
{
listBB.Dispose();
}
}
private void SetModel(ref WListData model)
{
model.workflowNo = this.workflowNo.Text;
model.workflowNm = this.workflowNm.Text;
model.workTableNm = this.workTableNm.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
//���ؿؼ�
WListBB listBB = new WListBB();
WListData listData = new WListData();
try
{
listData = listBB.GetModel(this.IdValue);
//����й��������˴�Ҫ��֤�Ƿ�������
this.ShowInfo(this.IdValue);
}
finally
{
listBB.Dispose();
}
break;
default:
break;
}
}
}
this.BindGrid(this.IdValue);
}
/// <summary>
/// ����һ������
/// </summary>
/// <param name="model">model</param>
public bool ModifyRecord(WListData model)
{
bool ret = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("update WList set ");
strSql.Append("workflowNm=@workflowNm,");
strSql.Append("workTableNm=@workTableNm,");
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 workflowNo = @workflowNo ");
SqlParameter[] parameters = {
new SqlParameter("@workflowNo", SqlDbType.NVarChar,50),
new SqlParameter("@workflowNm", SqlDbType.NVarChar,50),
new SqlParameter("@workTableNm", 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.workflowNo;
parameters[1].Value = model.workflowNm;
parameters[2].Value = model.workTableNm;
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="workflowNo">����ֵ</param>
/// <returns>model</returns>
public WListData GetModel(string workflowNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from WList");
strSql.Append(" where workflowNo = @workflowNo ");
SqlParameter[] parameters = {
new SqlParameter("@workflowNo", SqlDbType.NVarChar,50)
};
parameters[0].Value = workflowNo;
WListData model = new WListData();
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["workflowNo"] != DBNull.Value)
{
model.workflowNo = Convert.ToString(row["workflowNo"]);
}
if (row["workflowNm"] != DBNull.Value)
{
model.workflowNm = Convert.ToString(row["workflowNm"]);
}
if (row["workTableNm"] != DBNull.Value)
{
model.workTableNm = Convert.ToString(row["workTableNm"]);
}
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;
}
}
/// <summary>
/// ����һ������
/// </summary>
/// <param name="model">model</param>
public bool ModifyRecord(WListData model)
{
return this.listDB.ModifyRecord(model);
}
/// <summary>
/// ����һ������
/// </summary>
/// <param name="model">model</param>
public int AddRecord(WListData model)
{
return this.listDB.AddRecord(model);
}
