private Workflow_FieldDictEntity GetWorkflow_FieldDictFromIDataReader(DbDataReader dr) { Workflow_FieldDictEntity dt = new Workflow_FieldDictEntity(); if (dr.FieldCount > 0) { if (dr["FieldID"].ToString() != "" || dr["FieldID"] != null) dt.FieldID = Int32.Parse(dr["FieldID"].ToString()); dt.FieldName = dr["FieldName"].ToString(); dt.FieldDesc = dr["FieldDesc"].ToString(); if (dr["DataTypeID"].ToString() != "" || dr["DataTypeID"] != null) dt.DataTypeID = Int32.Parse(dr["DataTypeID"].ToString()); dt.FieldDBType = dr["FieldDBType"].ToString(); if (dr["HTMLTypeID"].ToString() != "" || dr["HTMLTypeID"] != null) dt.HTMLTypeID = Int32.Parse(dr["HTMLTypeID"].ToString()); if (dr["FieldTypeID"].ToString() != "" || dr["FieldTypeID"] != null) dt.FieldTypeID = Int32.Parse(dr["FieldTypeID"].ToString()); dt.ValidateType = dr["ValidateType"].ToString(); if (dr["TextLength"].ToString() != "" || dr["TextLength"] != null) dt.TextLength = Int32.Parse(dr["TextLength"].ToString()); dt.Dateformat = dr["Dateformat"].ToString(); if (dr["TextHeight"].ToString() != "" || dr["TextHeight"] != null) dt.TextHeight = Int32.Parse(dr["TextHeight"].ToString()); dt.IsHTML = dr["IsHTML"].ToString(); if (dr["BrowseType"].ToString() != "" || dr["BrowseType"] != null) dt.BrowseType = Int32.Parse(dr["BrowseType"].ToString()); dt.IsDynamic = dr["IsDynamic"].ToString(); dt.DataSetID = Convert.ToInt32(dr["DataSetID"]); dt.ValueColumn = dr["ValueColumn"].ToString(); dt.TextColumn = dr["TextColumn"].ToString(); dr.Close(); return dt; } dr.Close(); return null; }
/// <summary> /// 修改信息 /// </summary> /// <param name="_Workflow_FieldDictEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string UpdateWorkflow_FieldDict(Workflow_FieldDictEntity _Workflow_FieldDictEntity) { DbParameter[] pramsUpdate = { MakeInParam("@FieldID",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.FieldID ), MakeInParam("@FieldName",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.FieldName ), MakeInParam("@FieldDesc",(DbType)SqlDbType.VarChar,200,_Workflow_FieldDictEntity.FieldDesc ), MakeInParam("@DataTypeID",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.DataTypeID ), MakeInParam("@FieldDBType",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.FieldDBType ), MakeInParam("@HTMLTypeID",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.HTMLTypeID ), MakeInParam("@FieldTypeID",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.FieldTypeID ), MakeInParam("@ValidateType",(DbType)SqlDbType.VarChar,100,_Workflow_FieldDictEntity.ValidateType ), MakeInParam("@TextLength",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.TextLength ), MakeInParam("@Dateformat",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.Dateformat ), MakeInParam("@TextHeight",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.TextHeight ), MakeInParam("@IsHTML",(DbType)SqlDbType.Char,1,_Workflow_FieldDictEntity.IsHTML ), MakeInParam("@BrowseType",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.BrowseType ), MakeInParam("@IsDynamic",(DbType)SqlDbType.Char,1,_Workflow_FieldDictEntity.IsDynamic ), MakeInParam("@DataSetID",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.DataSetID ), MakeInParam("@ValueColumn",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.ValueColumn ), MakeInParam("@TextColumn",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.TextColumn ), MakeInParam("@DefaultValue",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.DefaultValue ), MakeInParam("@SqlDbType",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.SqlDbType ), MakeInParam("@SqlDbLength",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.SqlDbLength ), }; StringBuilder sb = new StringBuilder(); sb.Append("Update [dbo].[Workflow_FieldDict]"); sb.Append(" set "); sb.Append(" [FieldName]=@FieldName,"); sb.Append(" [FieldDesc]=@FieldDesc,"); sb.Append(" [DataTypeID]=@DataTypeID,"); sb.Append(" [FieldDBType]=@FieldDBType,"); sb.Append(" [HTMLTypeID]=@HTMLTypeID,"); sb.Append(" [FieldTypeID]=@FieldTypeID,"); sb.Append(" [ValidateType]=@ValidateType,"); sb.Append(" [TextLength]=@TextLength,"); sb.Append(" [Dateformat]=@Dateformat,"); sb.Append(" [TextHeight]=@TextHeight,"); sb.Append(" [IsHTML]=@IsHTML,"); sb.Append(" [BrowseType]=@BrowseType,"); sb.Append(" [IsDynamic]=@IsDynamic,"); sb.Append(" [DataSetID]=@DataSetID,"); sb.Append(" [ValueColumn]=@ValueColumn,"); sb.Append(" [TextColumn]=@TextColumn,"); sb.Append(" [DefaultValue]=@DefaultValue,"); sb.Append(" [SqlDbType]=@SqlDbType,"); sb.Append(" [SqlDbLength]=@SqlDbLength "); sb.Append(" where [FieldID]=@FieldID"); ExecuteNonQuery(CommandType.Text, sb.ToString(), pramsUpdate); DataTable dtSelectListNow = _Workflow_FieldDictEntity.dtSelectList; DataTable dtSelectListOrignal = GetDBRecords("*", "Workflow_FieldDictSelect", "FieldID=" + _Workflow_FieldDictEntity.FieldID, "DisplayOrder"); for (int i = 0; i < dtSelectListOrignal.Rows.Count; i++) { string SelectNo = dtSelectListOrignal.Rows[i]["SelectNo"].ToString(); if (dtSelectListNow.Select("SelectNo=" + SelectNo).Length < 1) { ExecuteNonQuery(CommandType.Text, "delete from [dbo].[Workflow_FieldDictSelect] where SelectNo=" + SelectNo); } } for (int i = 0; i < dtSelectListNow.Rows.Count; i++) { if (Convert.ToInt32(dtSelectListNow.Rows[i]["SelectNo"]) == 0) { DbParameter[] pramsInsertDetail = { MakeInParam("@FieldID",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.FieldID ), MakeInParam("@LabelWord",(DbType)SqlDbType.VarChar,200,dtSelectListNow.Rows[i]["LabelWord"] ), MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,dtSelectListNow.Rows[i]["DisplayOrder"] ), }; string sql = @"insert into [dbo].[Workflow_FieldDictSelect] (FieldID,LabelWord,DisplayOrder)values (@FieldID,@LabelWord,@DisplayOrder) select @@identity;"; ExecuteScalar(CommandType.Text, sql, pramsInsertDetail); } else { DbParameter[] pramsUpdateDetail = { MakeInParam("@SelectNo",(DbType)SqlDbType.Int,4,dtSelectListNow.Rows[i]["SelectNo"] ), MakeInParam("@LabelWord",(DbType)SqlDbType.VarChar,200,dtSelectListNow.Rows[i]["LabelWord"] ), MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,dtSelectListNow.Rows[i]["DisplayOrder"] ), }; string sql = @"update [dbo].[Workflow_FieldDictSelect] set LabelWord=@LabelWord,DisplayOrder=@DisplayOrder where SelectNo=@SelectNo"; ExecuteScalar(CommandType.Text, sql, pramsUpdateDetail); } } return "0"; }
private string SaveData() { Workflow_FieldDictEntity _Workflow_FieldDictEntity = new Workflow_FieldDictEntity(); _Workflow_FieldDictEntity.FieldID = Convert.ToInt32(txtFieldID.Value != string.Empty ? txtFieldID.Value : "0"); _Workflow_FieldDictEntity.FieldName = txtFieldName.Text; _Workflow_FieldDictEntity.FieldDesc = txtFieldDesc.Text; _Workflow_FieldDictEntity.DataTypeID = Convert.ToInt32(ddlDataType.SelectedValue); if (ddlHTMLType.SelectedValue == "1")//label { _Workflow_FieldDictEntity.FieldDBType = string.Format("{1}({0})", 200, SqlDbType.VarChar); _Workflow_FieldDictEntity.SqlDbType = SqlDbType.VarChar.ToString(); _Workflow_FieldDictEntity.SqlDbLength = 200; } else if (ddlHTMLType.SelectedValue == "2")//textbox { switch (ddlDataType.SelectedValue) { case "1": _Workflow_FieldDictEntity.FieldDBType = string.Format("{1}({0})", txtTextLength.Text, SqlDbType.VarChar); _Workflow_FieldDictEntity.SqlDbType = SqlDbType.VarChar.ToString(); _Workflow_FieldDictEntity.SqlDbLength = Convert.ToInt32(txtTextLength.Text); break; case "2": _Workflow_FieldDictEntity.FieldDBType = SqlDbType.BigInt.ToString(); _Workflow_FieldDictEntity.SqlDbType = SqlDbType.BigInt.ToString(); _Workflow_FieldDictEntity.SqlDbLength = 4; break; case "3": _Workflow_FieldDictEntity.FieldDBType = SqlDbType.Float.ToString(); _Workflow_FieldDictEntity.SqlDbType = SqlDbType.Float.ToString(); _Workflow_FieldDictEntity.SqlDbLength = 8; break; case "4": _Workflow_FieldDictEntity.FieldDBType = SqlDbType.DateTime.ToString(); _Workflow_FieldDictEntity.SqlDbType = SqlDbType.DateTime.ToString(); _Workflow_FieldDictEntity.SqlDbLength = 16; break; case "5": _Workflow_FieldDictEntity.FieldDBType = string.Format("{1}({0})", 8, SqlDbType.VarChar); _Workflow_FieldDictEntity.SqlDbType = SqlDbType.VarChar.ToString(); _Workflow_FieldDictEntity.SqlDbLength = 8; break; } } else if (ddlHTMLType.SelectedValue == "3")//textarea { _Workflow_FieldDictEntity.FieldDBType = string.Format("{1}({0})", 1000, SqlDbType.VarChar); _Workflow_FieldDictEntity.SqlDbType = SqlDbType.VarChar.ToString(); _Workflow_FieldDictEntity.SqlDbLength = 1000; } else if (ddlHTMLType.SelectedValue == "4" //checkboxlist || ddlHTMLType.SelectedValue == "5")//dropdownlist { _Workflow_FieldDictEntity.FieldDBType = string.Format("{1}({0})", 600, SqlDbType.VarChar); _Workflow_FieldDictEntity.SqlDbType = SqlDbType.VarChar.ToString(); _Workflow_FieldDictEntity.SqlDbLength = 600; } else if (ddlHTMLType.SelectedValue == "8")//browsebutton { _Workflow_FieldDictEntity.FieldDBType = string.Format("{1}({0})", 600, SqlDbType.VarChar); _Workflow_FieldDictEntity.SqlDbType = SqlDbType.VarChar.ToString(); _Workflow_FieldDictEntity.SqlDbLength = 600; } else if (ddlHTMLType.SelectedValue == "6" //checkbox || ddlHTMLType.SelectedValue == "7") //uploadfile { _Workflow_FieldDictEntity.FieldDBType = string.Format("{1}({0})", 50, SqlDbType.VarChar); _Workflow_FieldDictEntity.SqlDbType = SqlDbType.VarChar.ToString(); _Workflow_FieldDictEntity.SqlDbLength = 50; } else { _Workflow_FieldDictEntity.FieldDBType = string.Format("{1}({0})", 50, SqlDbType.VarChar); _Workflow_FieldDictEntity.SqlDbType = SqlDbType.VarChar.ToString(); _Workflow_FieldDictEntity.SqlDbLength = 50; } _Workflow_FieldDictEntity.HTMLTypeID = Convert.ToInt32(ddlHTMLType.Text); _Workflow_FieldDictEntity.FieldTypeID = Convert.ToInt32(rblFieldType.SelectedValue);//主字段/明细字段 _Workflow_FieldDictEntity.ValidateType = string.Empty; _Workflow_FieldDictEntity.TextLength = Convert.ToInt32(txtTextLength.Text != string.Empty ? txtTextLength.Text : "0"); _Workflow_FieldDictEntity.Dateformat = ddlDateformat.SelectedValue; _Workflow_FieldDictEntity.TextHeight = Convert.ToInt32(txtTextHeight.Text != string.Empty ? txtTextHeight.Text : "0"); _Workflow_FieldDictEntity.IsHTML = chkIsHTML.Checked ? "1" : "0"; _Workflow_FieldDictEntity.BrowseType = Convert.ToInt32(ddlBrowseType.SelectedValue); _Workflow_FieldDictEntity.IsDynamic = rblStaticOrDynamic.SelectedValue; _Workflow_FieldDictEntity.DataSetID = txtDataSetID.Value != string.Empty ? Convert.ToInt32(txtDataSetID.Value) : 0; _Workflow_FieldDictEntity.ValueColumn = ddlValueColumn.SelectedValue; _Workflow_FieldDictEntity.TextColumn = ddlTextColumn.SelectedValue; _Workflow_FieldDictEntity.dtSelectList = (DataTable)ViewState["dtSelectList"]; string sResult = "-1"; if (strOperationState == "Add") sResult = DbHelper.GetInstance().AddWorkflow_FieldDict(_Workflow_FieldDictEntity); else if (strOperationState == "Update") sResult = DbHelper.GetInstance().UpdateWorkflow_FieldDict(_Workflow_FieldDictEntity); return sResult; }
/// <summary> /// 新增信息 /// </summary> /// <param name="_Workflow_FieldDictEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string AddWorkflow_FieldDict(Workflow_FieldDictEntity _Workflow_FieldDictEntity) { //判断该记录是否已经存在 DbParameter[] prams = { MakeInParam("@FieldName",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.FieldName), MakeInParam("@FieldTypeID",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.FieldTypeID), }; string sql = " select * from [dbo].[Workflow_FieldDict] where FieldName=@FieldName and FieldTypeID=@FieldTypeID "; if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0) { return "-1";//该记录已经存在 } else { DbParameter[] pramsInsert = { MakeInParam("@FieldName",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.FieldName ), MakeInParam("@FieldDesc",(DbType)SqlDbType.VarChar,200,_Workflow_FieldDictEntity.FieldDesc ), MakeInParam("@DataTypeID",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.DataTypeID ), MakeInParam("@FieldDBType",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.FieldDBType ), MakeInParam("@HTMLTypeID",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.HTMLTypeID ), MakeInParam("@FieldTypeID",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.FieldTypeID ), MakeInParam("@ValidateType",(DbType)SqlDbType.VarChar,100,_Workflow_FieldDictEntity.ValidateType ), MakeInParam("@TextLength",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.TextLength ), MakeInParam("@Dateformat",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.Dateformat ), MakeInParam("@TextHeight",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.TextHeight ), MakeInParam("@IsHTML",(DbType)SqlDbType.Char,1,_Workflow_FieldDictEntity.IsHTML ), MakeInParam("@BrowseType",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.BrowseType ), MakeInParam("@IsDynamic",(DbType)SqlDbType.Char,1,_Workflow_FieldDictEntity.IsDynamic ), MakeInParam("@DataSetID",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.DataSetID ), MakeInParam("@ValueColumn",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.ValueColumn ), MakeInParam("@TextColumn",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.TextColumn ), MakeInParam("@DefaultValue",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.DefaultValue ), MakeInParam("@SqlDbType",(DbType)SqlDbType.VarChar,50,_Workflow_FieldDictEntity.SqlDbType ), MakeInParam("@SqlDbLength",(DbType)SqlDbType.Int,4,_Workflow_FieldDictEntity.SqlDbLength ), }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Workflow_FieldDict]"); sb.Append("("); sb.Append(" [FieldName]"); sb.Append(",[FieldDesc]"); sb.Append(",[DataTypeID]"); sb.Append(",[FieldDBType]"); sb.Append(",[HTMLTypeID]"); sb.Append(",[FieldTypeID]"); sb.Append(",[ValidateType]"); sb.Append(",[TextLength]"); sb.Append(",[Dateformat]"); sb.Append(",[TextHeight]"); sb.Append(",[IsHTML]"); sb.Append(",[BrowseType]"); sb.Append(",[IsDynamic]"); sb.Append(",[DataSetID]"); sb.Append(",[ValueColumn]"); sb.Append(",[TextColumn]"); sb.Append(",[DefaultValue]"); sb.Append(",[SqlDbType]"); sb.Append(",[SqlDbLength]"); sb.Append(") "); sb.Append(" VALUES ("); sb.Append("@FieldName,"); sb.Append("@FieldDesc,"); sb.Append("@DataTypeID,"); sb.Append("@FieldDBType,"); sb.Append("@HTMLTypeID,"); sb.Append("@FieldTypeID,"); sb.Append("@ValidateType,"); sb.Append("@TextLength,"); sb.Append("@Dateformat,"); sb.Append("@TextHeight,"); sb.Append("@IsHTML,"); sb.Append("@BrowseType,"); sb.Append("@IsDynamic,"); sb.Append("@DataSetID,"); sb.Append("@ValueColumn,"); sb.Append("@TextColumn,"); sb.Append("@DefaultValue,"); sb.Append("@SqlDbType,"); sb.Append("@SqlDbLength )"); sb.Append("select @@identity;"); string FieldID = ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); _Workflow_FieldDictEntity.FieldID = Convert.ToInt32(FieldID); DataTable dtSelectListNow = _Workflow_FieldDictEntity.dtSelectList; for (int i = 0; i < dtSelectListNow.Rows.Count; i++) { if (Convert.ToInt32(dtSelectListNow.Rows[i]["SelectNo"]) == 0) { DbParameter[] pramsInsertDetail = { MakeInParam("@FieldID",(DbType)SqlDbType.Int,4,FieldID ), MakeInParam("@LabelWord",(DbType)SqlDbType.VarChar,200,dtSelectListNow.Rows[i]["LabelWord"] ), MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,dtSelectListNow.Rows[i]["DisplayOrder"] ), }; string sqlInsertDetail = @"insert into [dbo].[Workflow_FieldDictSelect] (FieldID,LabelWord,DisplayOrder)values (@FieldID,@LabelWord,@DisplayOrder) select @@identity;"; ExecuteScalar(CommandType.Text, sqlInsertDetail, pramsInsertDetail); } else { DbParameter[] pramsUpdateDetail = { MakeInParam("@SelectNo",(DbType)SqlDbType.Int,4,dtSelectListNow.Rows[i]["SelectNo"] ), MakeInParam("@LabelWord",(DbType)SqlDbType.VarChar,200,dtSelectListNow.Rows[i]["LabelWord"] ), MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,dtSelectListNow.Rows[i]["DisplayOrder"] ), }; string sqlUpdateDetail = @"update [dbo].[Workflow_FieldDictSelect] set LabelWord=@LabelWord,DisplayOrder=@DisplayOrder where SelectNo=@SelectNo"; ExecuteScalar(CommandType.Text, sqlUpdateDetail, pramsUpdateDetail); } } return "0"; } }
/// <summary> /// 增加字段 /// </summary> /// <param name="item">xml数据</param> /// <returns>FieldID数组</returns> private static List<int> addFieldDict(out List<string> FD, out List<int> CSS, out List<string> Group, out List<int> GroupLineDataSetID, XmlNodeList item, XmlNodeList options) { FD = new List<string>(); //字段描述 CSS = new List<int>(); // Group = new List<string>(); // GroupLineDataSetID = new List<int>(); // List<int> result = new List<int>(); foreach (XmlNode fNode in item) { GPRP.Entity.Workflow_FieldDictEntity test = new GPRP.Entity.Workflow_FieldDictEntity(); XmlNode FieldID = fNode.SelectSingleNode("FieldID"); XmlNode FieldName = fNode.SelectSingleNode("FieldName"); XmlNode FieldDesc = fNode.SelectSingleNode("FieldDesc"); XmlNode DataTypeID = fNode.SelectSingleNode("DataTypeID"); XmlNode FieldDBType = fNode.SelectSingleNode("FieldDBType"); XmlNode SqlDbType = fNode.SelectSingleNode("SqlDbType"); XmlNode SqlDbLength = fNode.SelectSingleNode("SqlDbLength"); XmlNode HTMLTypeID = fNode.SelectSingleNode("HTMLTypeID"); XmlNode FieldTypeID = fNode.SelectSingleNode("FieldTypeID"); XmlNode TextLength = fNode.SelectSingleNode("TextLength"); XmlNode Dateformat = fNode.SelectSingleNode("Dateformat"); XmlNode IsHTML = fNode.SelectSingleNode("IsHTML"); XmlNode TextHeight = fNode.SelectSingleNode("TextHeight"); XmlNode BrowseType = fNode.SelectSingleNode("BrowseType"); XmlNode IsDynamic = fNode.SelectSingleNode("IsDynamic"); XmlNode DataSetID = fNode.SelectSingleNode("DataSetID"); XmlNode BuiltInFlag = fNode.SelectSingleNode("BuiltInFlag"); XmlNode CSSStyleClass = fNode.SelectSingleNode("CSSStyleClass"); XmlNode group = fNode.SelectSingleNode("group"); //对应明细组 XmlNode groupLineDataSetID = fNode.SelectSingleNode("GroupLineDataSetID"); //对应明细行数据集 test.FieldID = (FieldID.InnerText != string.Empty ? Convert.ToInt32(FieldID.InnerText) : 0); test.FieldName = FieldName.InnerText; test.FieldDesc = FieldDesc.InnerText; test.DataTypeID =( DataTypeID.InnerText!=null?Convert.ToInt32(DataTypeID.InnerText):0); test.FieldDBType = FieldDBType.InnerText; test.SqlDbType = SqlDbType.InnerText; test.SqlDbLength =(SqlDbLength.InnerText!=null?Convert.ToInt32(SqlDbLength.InnerText):0); test.HTMLTypeID =( HTMLTypeID.InnerText!=null?Convert.ToInt32(HTMLTypeID.InnerText):0); test.FieldTypeID =(FieldTypeID.InnerText != null ? Convert.ToInt32(FieldTypeID.InnerText) : 0); test.IsDynamic = IsDynamic.InnerText; test.TextLength =TextLength.InnerText!=null ? Convert.ToInt32(TextLength.InnerText):0; DataTable dt = addFieldSelect(options); //下拉框选项 test.dtSelectList = dt; test.Dateformat = Dateformat.InnerText; test.IsHTML = IsHTML.InnerText; test.TextHeight =TextHeight.InnerText!=null? Convert.ToInt32(TextHeight.InnerText):0; test.BrowseType = BrowseType.InnerText!=null? Convert.ToInt32(BrowseType.InnerText):0; test.IsDynamic = IsDynamic.InnerText; test.DataSetID =DataSetID.InnerText!=null?Convert.ToInt32(DataSetID.InnerText):0; test.ValidateType = ""; test.ValueColumn = ""; test.TextColumn = ""; string r = "-1"; if (test.FieldID != 0) { r = DbHelper.GetInstance().UpdateWorkflow_FieldDict(test); //修改字段 } else { r = DbHelper.GetInstance().AddWorkflow_FieldDict(test); //增加字段 } if (r != "-1") { FD.Add(FieldDesc.InnerText); Group.Add(group.InnerText); GroupLineDataSetID.Add(Convert.ToInt32(groupLineDataSetID.InnerText)); if (CSSStyleClass.InnerText == "") CSS.Add(-1); else CSS.Add(Convert.ToInt32(CSSStyleClass.InnerText)); result.Add(test.FieldID); } } return result; }