protected void btnSubmit_Click(object sender, EventArgs e)
{
DbHelper.GetInstance().DeleteWorkflow_GroupLineFieldMap(DNTRequest.GetString("fmid"), DNTRequest.GetString("fdid"));
for (int i = 0; i < GridView1.Rows.Count; i++)
{
string Prefix = "GridView1$ctl" + (i + 2).ToString().PadLeft(2, '0') + "$";
Workflow_GroupLineFieldMapEntity _GroupLineFieldMapEntity = new Workflow_GroupLineFieldMapEntity();
_GroupLineFieldMapEntity.FormID = DNTRequest.GetInt("fmid", 0);
_GroupLineFieldMapEntity.FieldID = DNTRequest.GetInt("fdid", 0);
_GroupLineFieldMapEntity.DataSetColumn = DNTRequest.GetString(Prefix + "DataSetColumn");
_GroupLineFieldMapEntity.TargetGroupField = GridView1.DataKeys[i][1].ToString();
DbHelper.GetInstance().AddWorkflow_GroupLineFieldMap(_GroupLineFieldMapEntity);
}
ScriptManager.RegisterStartupScript(btnSubmit, this.GetType(), "btnSubmit", "alert('设定成功');", true);
BindGridView();
}
/// <summary>
/// 新增信息
/// </summary>
/// <param name="_Workflow_GroupLineFieldMapEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddWorkflow_GroupLineFieldMap(Workflow_GroupLineFieldMapEntity _Workflow_GroupLineFieldMapEntity)
{
DbParameter[] pramsInsert = {
MakeInParam("@FormID",(DbType)SqlDbType.Int,4,_Workflow_GroupLineFieldMapEntity.FormID ),
MakeInParam("@FieldID",(DbType)SqlDbType.Int,4,_Workflow_GroupLineFieldMapEntity.FieldID ),
MakeInParam("@DataSetColumn",(DbType)SqlDbType.VarChar,50,_Workflow_GroupLineFieldMapEntity.DataSetColumn ),
MakeInParam("@TargetGroupField",(DbType)SqlDbType.VarChar,50,_Workflow_GroupLineFieldMapEntity.TargetGroupField ),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_GroupLineFieldMap]");
sb.Append("(");
sb.Append(" [FormID]");
sb.Append(",[FieldID]");
sb.Append(",[DataSetColumn]");
sb.Append(",[TargetGroupField]");
sb.Append(") ");
sb.Append(" VALUES (");
sb.Append("@FormID,");
sb.Append("@FieldID,");
sb.Append("@DataSetColumn,");
sb.Append("@TargetGroupField )");
sb.Append("select @@identity;");
return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
}
