| | |
| | | foreach (Model.ClsXt_DefineBillMainSetSub oSub in DetailColl) |
| | | { |
| | | string subSql = "Insert into Xt_DefineBillMainSetSub " + |
| | | " (HInterID,HEntryID,HArrangeOrder,HArrangeOrderSub,HIsHide,HIsDisabled,HIsMust,HParentElementID,HElementID" + |
| | | " (HInterID,HEntryID,HArrangeOrder,HArrangeOrderSub,HIsHide,HIsDisabled,HIsMust,HParentElementID,HElementID,HElementIDAdditionalName" + |
| | | ",HElementLabel,HElementType,HFieldMaxLength,HDefaultValue,HFieldName,HFieldDataType,HRelateUrl,HSubWindowBackData" + |
| | | ",HSubWindowBackDataMethodName,HSelectContent" + |
| | | ") values(" + |
| | |
| | | ",'" + (oSub.HIsMust ? 1 : 0) + "'" + |
| | | ",'" + oSub.HParentElementID + "'" + |
| | | ",'" + oSub.HElementID + "'" + |
| | | ",'" + oSub.HElementIDAdditionalName + "'" + |
| | | ",'" + oSub.HElementLabel + "'" + |
| | | ",'" + oSub.HElementType + "'" + |
| | | ",'" + oSub.HFieldMaxLength + "'" + |
| | |
| | | foreach (Model.ClsXt_DefineBillMainSetSub oSub in DetailColl) |
| | | { |
| | | string subSql = "Insert into Xt_DefineBillMainSetSub " + |
| | | " (HInterID,HEntryID,HArrangeOrder,HArrangeOrderSub,HIsHide,HIsDisabled,HIsMust,HParentElementID,HElementID" + |
| | | " (HInterID,HEntryID,HArrangeOrder,HArrangeOrderSub,HIsHide,HIsDisabled,HIsMust,HParentElementID,HElementID,HElementIDAdditionalName" + |
| | | ",HElementLabel,HElementType,HFieldMaxLength,HDefaultValue,HFieldName,HFieldDataType,HRelateUrl,HSubWindowBackData" + |
| | | ",HSubWindowBackDataMethodName,HSelectContent" + |
| | | ") values(" + |
| | |
| | | ",'" + (oSub.HIsMust?1:0) + "'" + |
| | | ",'" + oSub.HParentElementID + "'" + |
| | | ",'" + oSub.HElementID + "'" + |
| | | ",'" + oSub.HElementIDAdditionalName + "'" + |
| | | ",'" + oSub.HElementLabel + "'" + |
| | | ",'" + oSub.HElementType + "'" + |
| | | ",'" + oSub.HFieldMaxLength + "'" + |
| | |
| | | oSub.HIsMust = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HIsMust"]) == 1 ? true : false; |
| | | oSub.HParentElementID = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HParentElementID"]); |
| | | oSub.HElementID = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HElementID"]); |
| | | oSub.HElementIDAdditionalName = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HElementIDAdditionalName"]); |
| | | oSub.HElementLabel = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HElementLabel"]); |
| | | oSub.HElementType = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HElementType"]); |
| | | oSub.HFieldMaxLength = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HFieldMaxLength"]); |