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;
}
