private Workflow_BasicValidTypeEntity GetWorkflow_BasicValidTypeFromIDataReader(DbDataReader dr)
{
Workflow_BasicValidTypeEntity dt = new Workflow_BasicValidTypeEntity();
if (dr.FieldCount > 0)
{
if (dr["ValidTypeID"].ToString() != "" || dr["ValidTypeID"] != null) dt.ValidTypeID = Int32.Parse(dr["ValidTypeID"].ToString());
dt.ValidTypeDesc = dr["ValidTypeDesc"].ToString();
dt.ValidErrorMsg = dr["ValidErrorMsg"].ToString();
dt.ValidRule = (dr["ValidRule"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
/// <summary>
/// 修改信息
/// </summary>
/// <param name="_Workflow_BasicValidTypeEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string UpdateWorkflow_BasicValidType(Workflow_BasicValidTypeEntity _Workflow_BasicValidTypeEntity)
{
DbParameter[] pramsUpdate = {
MakeInParam("@ValidTypeDesc",(DbType)SqlDbType.VarChar,200,_Workflow_BasicValidTypeEntity.ValidTypeDesc ),
MakeInParam("@ValidErrorMsg",(DbType)SqlDbType.VarChar,200,_Workflow_BasicValidTypeEntity.ValidErrorMsg ),
MakeInParam("@ValidRule",(DbType)SqlDbType.VarChar,200,_Workflow_BasicValidTypeEntity.ValidRule ),
MakeInParam("@ValidTypeID",(DbType)SqlDbType.Int,4,_Workflow_BasicValidTypeEntity.ValidTypeID )
};
StringBuilder sb = new StringBuilder();
sb.Append("Update [dbo].[Workflow_BasicValidType]");
sb.Append(" set ");
sb.Append(" [ValidTypeDesc]=@ValidTypeDesc,");
sb.Append(" [ValidErrorMsg]=@ValidErrorMsg,");
sb.Append(" [ValidRule]=@ValidRule");
sb.Append(" where [ValidTypeID]=@ValidTypeID;select @@rowcount");
return ExecuteNonQuery(CommandType.Text, sb.ToString(), pramsUpdate).ToString();
}
/// <summary>
/// 新增信息
/// </summary>
/// <param name="_Workflow_BasicValidTypeEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddWorkflow_BasicValidType(Workflow_BasicValidTypeEntity _Workflow_BasicValidTypeEntity)
{
DbParameter[] pramsInsert = {
MakeInParam("@ValidTypeDesc",(DbType)SqlDbType.VarChar,200,_Workflow_BasicValidTypeEntity.ValidTypeDesc ),
MakeInParam("@ValidErrorMsg",(DbType)SqlDbType.VarChar,200,_Workflow_BasicValidTypeEntity.ValidErrorMsg ),
MakeInParam("@ValidRule",(DbType)SqlDbType.VarChar,200,_Workflow_BasicValidTypeEntity.ValidRule )
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_BasicValidType]");
sb.Append("(");
sb.Append("[ValidTypeDesc]");
sb.Append(",[ValidErrorMsg]");
sb.Append(",[ValidRule]");
sb.Append(") ");
sb.Append(" VALUES (");
sb.Append("@ValidTypeDesc,");
sb.Append("@ValidErrorMsg,");
sb.Append("@ValidRule);");
sb.Append("select @@identity;");
return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
}
//此类要更改，因为只考虑了TextBox值的赋值过程
private void SetPannelData(Workflow_BasicValidTypeEntity _Workflow_BasicValidTypeEntity)
{
//BindDropDownList(_psacnEntity.PSACNDAT);
txtValidTypeID.Value = _Workflow_BasicValidTypeEntity.ValidTypeID.ToString(); //验证方式编号
if (_Workflow_BasicValidTypeEntity.ValidTypeDesc != null) txtValidTypeDesc.Text = _Workflow_BasicValidTypeEntity.ValidTypeDesc.ToString(); //验证方式描述
if (_Workflow_BasicValidTypeEntity.ValidErrorMsg != null) txtValidErrorMsg.Text = _Workflow_BasicValidTypeEntity.ValidErrorMsg.ToString(); //验证不通过时的提示信息
if (_Workflow_BasicValidTypeEntity.ValidRule != null) txtValidRule.Text = _Workflow_BasicValidTypeEntity.ValidRule.ToString(); //验证用的正则表达式
strOperationState = "Update";
}
//此类要更改,完成赋值工作
private string SaveData()
{
Workflow_BasicValidTypeEntity _Workflow_BasicValidTypeEntity = new Workflow_BasicValidTypeEntity();
_Workflow_BasicValidTypeEntity.ValidTypeID = (txtValidTypeID.Value.Trim() == "" || txtValidTypeID.Value == null) ? 0 : Convert.ToInt32(txtValidTypeID.Value);
_Workflow_BasicValidTypeEntity.ValidTypeDesc = txtValidTypeDesc.Text;
_Workflow_BasicValidTypeEntity.ValidErrorMsg = txtValidErrorMsg.Text;
_Workflow_BasicValidTypeEntity.ValidRule = txtValidRule.Text;
string sResult = "-1";
if (strOperationState == "Add")
sResult = DbHelper.GetInstance().AddWorkflow_BasicValidType(_Workflow_BasicValidTypeEntity);
else if (strOperationState == "Update")
sResult = DbHelper.GetInstance().UpdateWorkflow_BasicValidType(_Workflow_BasicValidTypeEntity);
return sResult;
}
//1。更改key字段在GridView中的哪一行，默认都是第5行，第一二列为button 第三列为checkBox 第四列为edit字段，第五列 关键字列
//2。通过关键字获取单条记录。
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
int index = -1;
if (e.CommandName == "select")
{
programmaticAddModalPopup.Show();
strOperationState = "Update";
index = Convert.ToInt32(e.CommandArgument); //获取行号
string keyCol = GridView1.DataKeys[index].Value.ToString();
//第二处待修改位置
Workflow_BasicValidTypeEntity _Workflow_BasicValidTypeEntity = new Workflow_BasicValidTypeEntity();
_Workflow_BasicValidTypeEntity = DbHelper.GetInstance().GetWorkflow_BasicValidTypeEntityByKeyCol(keyCol);
if (_Workflow_BasicValidTypeEntity != null) SetPannelData(_Workflow_BasicValidTypeEntity);
}
}
