private void ShowInfo(string id)
{
MBusinessFunctionBB businessFunctionBB = new MBusinessFunctionBB();
vMBusinessFunctionData model = new vMBusinessFunctionData();
try
{
model = businessFunctionBB.GetVModel(id);
this.functionNo.Text = model.functionNo;
this.functionNm.Text = model.functionNm;
//this.functionUrl.Text = model.functionUrl;
this.acceptEmp.Text = model.acceptEmp;
this.isUseEmpAccept.Text = model.isUseEmpAccept.ToString();
this.isUseEmpLeaderAccept.Text = model.isUseEmpLeaderAccept.ToString();
this.useEmpField.Text = model.useEmpField;
this.windowheight.Text = model.windowheight.ToString();
this.windowwidth.Text = model.windowwidth.ToString();
this.isDraw.Text = model.isDraw.ToString();
this.remark.Text = model.remark;
}
finally
{
businessFunctionBB.Dispose();
}
}
/// <summary>
/// �õ�һ����ͼmodel
/// </summary>
/// <param name="functionNo">����ֵ</param>
/// <returns>model</returns>
public vMBusinessFunctionData GetVModel(string functionNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from vMBusinessFunction");
strSql.Append(" where functionNo = @functionNo ");
SqlParameter[] parameters = {
new SqlParameter("@functionNo", SqlDbType.NVarChar,20)
};
parameters[0].Value = functionNo;
vMBusinessFunctionData model = new vMBusinessFunctionData();
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["functionNo"] != DBNull.Value)
{
model.functionNo = Convert.ToString(row["functionNo"]);
}
if (row["functionNm"] != DBNull.Value)
{
model.functionNm = Convert.ToString(row["functionNm"]);
}
if (row["functionUrl"] != DBNull.Value)
{
model.functionUrl = Convert.ToString(row["functionUrl"]);
}
if (row["acceptEmp"] != DBNull.Value)
{
model.acceptEmp = Convert.ToString(row["acceptEmp"]);
}
if (row["isUseEmpAccept"] != DBNull.Value)
{
model.isUseEmpAccept = Convert.ToBoolean(row["isUseEmpAccept"]);
}
if (row["isUseEmpLeaderAccept"] != DBNull.Value)
{
model.isUseEmpLeaderAccept = Convert.ToBoolean(row["isUseEmpLeaderAccept"]);
}
if (row["useEmpField"] != DBNull.Value)
{
model.useEmpField = Convert.ToString(row["useEmpField"]);
}
if (row["windowheight"] != DBNull.Value)
{
model.windowheight = Convert.ToInt32(row["windowheight"]);
}
if (row["windowwidth"] != DBNull.Value)
{
model.windowwidth = Convert.ToInt32(row["windowwidth"]);
}
if (row["isDraw"] != DBNull.Value)
{
model.isDraw = Convert.ToBoolean(row["isDraw"]);
}
if (row["remark"] != DBNull.Value)
{
model.remark = Convert.ToString(row["remark"]);
}
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["isRun"] != DBNull.Value)
{
model.isRun = Convert.ToBoolean(row["isRun"]);
}
if (row["stopMark"] != DBNull.Value)
{
model.stopMark = Convert.ToString(row["stopMark"]);
}
if (row["messageNo"] != DBNull.Value)
{
model.messageNo = Convert.ToString(row["messageNo"]);
}
return model;
}
else
{
return null;
}
}
