protected void btnSubmit_Click(object sender, EventArgs e)
{
int NodeID = DNTRequest.GetInt("id", 0);
int GroupID = DNTRequest.GetInt("gid", 0);
Workflow_NodeDetailFieldControlEntity _NodeDetailFieldControlEntity = new Workflow_NodeDetailFieldControlEntity();
_NodeDetailFieldControlEntity.NodeID = NodeID;
_NodeDetailFieldControlEntity.GroupID = GroupID;
_NodeDetailFieldControlEntity.IsView = chkIsView.Checked ? 1 : 0;
_NodeDetailFieldControlEntity.IsAdd = chkIsAdd.Checked ? 1 : 0;
_NodeDetailFieldControlEntity.IsEdit = chkIsEdit.Checked ? 1 : 0;
_NodeDetailFieldControlEntity.IsDelete = chkIsDelete.Checked ? 1 : 0;
DbHelper.GetInstance().UpdateWorkflow_NodeDetailFieldControl(_NodeDetailFieldControlEntity);
DbHelper.GetInstance().DeleteWorkflow_NodeDetailFieldControlDetail(DNTRequest.GetString("id"), DNTRequest.GetString("gid"));
Workflow_NodeDetailFieldControlDetailEntity _NodeDetailFieldControlDetailEntity = new Workflow_NodeDetailFieldControlDetailEntity();
_NodeDetailFieldControlDetailEntity.NodeID = DNTRequest.GetInt("id", 0);
_NodeDetailFieldControlDetailEntity.GroupID = DNTRequest.GetInt("gid", 0);
for (int i = 0; i < GridView1.Rows.Count; i++)
{
string Prefix = "GridView1$ctl" + (i + 2).ToString().PadLeft(2, '0') + "$";
_NodeDetailFieldControlDetailEntity.FieldID = Convert.ToInt32(GridView1.DataKeys[i][0]);
_NodeDetailFieldControlDetailEntity.IsView = DNTRequest.GetString(Prefix + "IsView") == "on" ? 1 : 0;
_NodeDetailFieldControlDetailEntity.IsEdit = DNTRequest.GetString(Prefix + "IsEdit") == "on" ? 1 : 0;
_NodeDetailFieldControlDetailEntity.IsMandatory = DNTRequest.GetString(Prefix + "IsMandatory") == "on" ? 1 : 0;
_NodeDetailFieldControlDetailEntity.BasicValidType = DNTRequest.GetInt("txtBasicValidTypeID" + (i + 2).ToString().PadLeft(2, '0'), 0);
_NodeDetailFieldControlDetailEntity.ValidTimeType = DNTRequest.GetInt(Prefix + "ValidTimeType", 0);
DbHelper.GetInstance().AddWorkflow_NodeDetailFieldControlDetail(_NodeDetailFieldControlDetailEntity);
}
ScriptManager.RegisterStartupScript(btnSubmit, this.GetType(), "btnSubmit", "alert('设定成功');", true);
BindGridView();
}
/// <summary>
/// 更新信息
/// </summary>
/// <param name="_Workflow_NodeDetailFieldControlEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string UpdateWorkflow_NodeDetailFieldControl(Workflow_NodeDetailFieldControlEntity _Workflow_NodeDetailFieldControlEntity)
{
DbParameter[] pramsDelete = {
MakeInParam("@NodeID",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlEntity.NodeID ),
MakeInParam("@GroupID",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlEntity.GroupID ),
};
ExecuteNonQuery(CommandType.Text, "delete from [dbo].[Workflow_NodeDetailFieldControl] where NodeID=@NodeID and GroupID=@GroupID", pramsDelete);
DbParameter[] pramsInsert = {
MakeInParam("@NodeID",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlEntity.NodeID ),
MakeInParam("@GroupID",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlEntity.GroupID ),
MakeInParam("@IsView",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlEntity.IsView ),
MakeInParam("@IsAdd",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlEntity.IsAdd ),
MakeInParam("@IsEdit",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlEntity.IsEdit ),
MakeInParam("@IsDelete",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlEntity.IsDelete ),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_NodeDetailFieldControl]");
sb.Append("(");
sb.Append(" [NodeID]");
sb.Append(",[GroupID]");
sb.Append(",[IsView]");
sb.Append(",[IsAdd]");
sb.Append(",[IsEdit]");
sb.Append(",[IsDelete]");
sb.Append(") ");
sb.Append(" VALUES (");
sb.Append("@NodeID,");
sb.Append("@GroupID,");
sb.Append("@IsView,");
sb.Append("@IsAdd,");
sb.Append("@IsEdit,");
sb.Append("@IsDelete )");
sb.Append("select @@identity;");
return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
}
/// <summary>
/// 返回实体内容
/// </summary>
/// <param name="NodeID"></param>
/// <param name="GroupID"></param>
/// <returns></returns>
public Workflow_NodeDetailFieldControlEntity GetWorkflow_NodeDetailFieldControlEntityByKeyCol(string NodeID, string GroupID)
{
string sql = "select * from [dbo].[Workflow_NodeDetailFieldControl] Where NodeID=@NodeID and GroupID=@GroupID";
DbParameter[] pramsGet = {
MakeInParam("@NodeID",(DbType)SqlDbType.VarChar,50,NodeID ),
MakeInParam("@GroupID",(DbType)SqlDbType.VarChar,50,GroupID ),
};
Workflow_FlowNodeEntity _FlowNodeEntity = GetWorkflow_FlowNodeEntityByKeyCol(NodeID);
Workflow_NodeDetailFieldControlEntity dt = new Workflow_NodeDetailFieldControlEntity();
dt.NodeID = Int32.Parse(NodeID);
dt.GroupID = Int32.Parse(GroupID);
DbDataReader sr = null;
try
{
sr = ExecuteReader(CommandType.Text, sql, pramsGet);
if (sr.Read())
{
if (sr["NodeID"].ToString() != "" || sr["NodeID"] != null) dt.NodeID = Int32.Parse(sr["NodeID"].ToString());
if (sr["GroupID"].ToString() != "" || sr["GroupID"] != null) dt.GroupID = Int32.Parse(sr["GroupID"].ToString());
if (sr["IsView"].ToString() != "" || sr["IsView"] != null) dt.IsView = Int32.Parse(sr["IsView"].ToString());
if (sr["IsAdd"].ToString() != "" || sr["IsAdd"] != null) dt.IsAdd = Int32.Parse(sr["IsAdd"].ToString());
if (sr["IsEdit"].ToString() != "" || sr["IsEdit"] != null) dt.IsEdit = Int32.Parse(sr["IsEdit"].ToString());
if (sr["IsDelete"].ToString() != "" || sr["IsDelete"] != null) dt.IsDelete = Int32.Parse(sr["IsDelete"].ToString());
sr.Close();
}
else
{
dt.IsView = 1;
dt.IsAdd = _FlowNodeEntity.NodeTypeID == 1 ? 1 : 0;
dt.IsEdit = _FlowNodeEntity.NodeTypeID == 1 ? 1 : 0;
dt.IsDelete = _FlowNodeEntity.NodeTypeID == 1 ? 1 : 0;
}
return dt;
}
catch (Exception exp)
{
throw exp;
}
finally
{
if (sr != null)
sr.Close();
}
}
