protected void btnInfoFromDocBatch_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = GetTemplateColumn(dt);
dt = FileLibrary.GetDataFromWordBatch(ConstantsManager.WEBSITE_VIRTUAL_ROOT_DIR + "/" + ConstantsManager.UPLOAD_DOC_DIR + "/" + "T_BM_KCYYXX", dt, true, true);
T_BM_KCYYXXApplicationLogic instanceT_BM_KCYYXXApplicationLogic = (T_BM_KCYYXXApplicationLogic)CreateApplicationLogicInstance(typeof(T_BM_KCYYXXApplicationLogic));
foreach (DataRow dr in dt.Rows)
{
appData = new T_BM_KCYYXXApplicationData();
appData.KCYYBH = instanceT_BM_KCYYXXApplicationLogic.AutoGenerateKCYYBH(appData);
int i = 0;
appData = instanceT_BM_KCYYXXApplicationLogic.Add(appData);
}
}
//=====================================================================
// FunctionName : GetAddInputParameter
/// <summary>
/// 得到添加用户输入参数操作
/// </summary>
//=====================================================================
protected override Boolean GetAddInputParameter()
{
Boolean boolReturn = true;
ValidateData validateData = new ValidateData();
// 验证输入参数
validateData = ValidateKCBBH(KCBBH.SelectedValue, false, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.KCBBH = Convert.ToString(validateData.Value.ToString());
}
KCBBH.BackColor = System.Drawing.Color.Empty;
}
else
{
KCBBH.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
validateData = ValidateHYBH(HYBH.SelectedValue, false, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.HYBH = Convert.ToString(validateData.Value.ToString());
}
HYBH.BackColor = System.Drawing.Color.Empty;
}
else
{
HYBH.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
validateData = ValidateYYSJ(YYSJ.Text, false, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.YYSJ = Convert.ToDateTime(validateData.Value.ToString());
}
YYSJ.BackColor = System.Drawing.Color.Empty;
}
else
{
YYSJ.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
validateData = ValidateYYBZ(YYBZ.Text, true, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.YYBZ = Convert.ToString(validateData.Value.ToString());
}
YYBZ.BackColor = System.Drawing.Color.Empty;
}
else
{
YYBZ.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
validateData = ValidateSKZT(SKZT.Text, true, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.SKZT = Convert.ToString(validateData.Value.ToString());
}
SKZT.BackColor = System.Drawing.Color.Empty;
}
else
{
SKZT.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
validateData = ValidateXHKS(XHKS.Text, true, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.XHKS = Convert.ToInt32(validateData.Value.ToString());
}
XHKS.BackColor = System.Drawing.Color.Empty;
}
else
{
XHKS.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
if (KTZP.Upload())
{
appData.KTZP = KTZP.Text;
}
else
{
MessageContent += @"<font color=""red"">" + KTZP.Message + "</font>";
boolReturn = false;
}
validateData = ValidateJSPJ(JSPJ.Text, true, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.JSPJ = Convert.ToString(validateData.Value.ToString());
}
JSPJ.BackColor = System.Drawing.Color.Empty;
}
else
{
JSPJ.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
validateData = ValidatePJR(PJR.Text, true, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.PJR = Convert.ToString(validateData.Value.ToString());
}
PJR.BackColor = System.Drawing.Color.Empty;
}
else
{
PJR.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
validateData = ValidatePJSJ(PJSJ.Text, true, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.PJSJ = Convert.ToDateTime(validateData.Value.ToString());
}
PJSJ.BackColor = System.Drawing.Color.Empty;
}
else
{
PJSJ.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
// 自动生成编号
T_BM_KCYYXXApplicationLogic instanceT_BM_KCYYXXApplicationLogic
= (T_BM_KCYYXXApplicationLogic)CreateApplicationLogicInstance(typeof(T_BM_KCYYXXApplicationLogic));
appData.KCYYBH = instanceT_BM_KCYYXXApplicationLogic.AutoGenerateKCYYBH(appData);
return(boolReturn);
}
protected void btnInfoFromDS_Click(object sender, EventArgs e)
{
int totalCount = 0;
int importCount = 0;
int updateCount = 0;
try
{
var appDatas = T_BM_KCYYXXApplicationData.GetDataFromDataFile <T_BM_KCYYXXApplicationData>(InfoFromDoc.Text, true, true, recordStartLine: T_BM_KCYYXXContants.ImportDataSetStartLineNum);
T_BM_KCYYXXApplicationLogic instanceT_BM_KCYYXXApplicationLogic = (T_BM_KCYYXXApplicationLogic)CreateApplicationLogicInstance(typeof(T_BM_KCYYXXApplicationLogic));
totalCount = appDatas.Count;
foreach (var app in appDatas)
{
app.KCYYBH = instanceT_BM_KCYYXXApplicationLogic.AutoGenerateKCYYBH(app);
string strKCBBH = GetValue(new RICH.Common.BM.T_BM_KCBXX.T_BM_KCBXXApplicationLogicBase().GetValueByFixCondition("KCBH", app.KCBBH, "KCBBH"));
if (!DataValidateManager.ValidateIsNull(strKCBBH))
{
app.KCBBH = strKCBBH;
}
if (!KCBBH.SelectedValue.IsHtmlNullOrWiteSpace())
{
app.KCBBH = Convert.ToString(KCBBH.SelectedValue);
}
string strHYBH = GetValue(new RICH.Common.BM.T_BM_HYXX.T_BM_HYXXApplicationLogicBase().GetValueByFixCondition("HYXM", app.HYBH, "HYBH"));
if (!DataValidateManager.ValidateIsNull(strHYBH))
{
app.HYBH = strHYBH;
}
if (!HYBH.SelectedValue.IsHtmlNullOrWiteSpace())
{
app.HYBH = Convert.ToString(HYBH.SelectedValue);
}
if (!YYSJ.Text.IsHtmlNullOrWiteSpace())
{
app.YYSJ = Convert.ToDateTime(YYSJ.Text);
}
if (!YYBZ.Text.IsHtmlNullOrWiteSpace())
{
app.YYBZ = Convert.ToString(YYBZ.Text);
}
if (!SKZT.Text.IsHtmlNullOrWiteSpace())
{
app.SKZT = Convert.ToString(SKZT.Text);
}
if (!XHKS.Text.IsHtmlNullOrWiteSpace())
{
app.XHKS = Convert.ToInt32(XHKS.Text);
}
if (!KTZP.Text.IsHtmlNullOrWiteSpace())
{
app.KTZP = Convert.ToString(KTZP.Text);
}
if (!JSPJ.Text.IsHtmlNullOrWiteSpace())
{
app.JSPJ = Convert.ToString(JSPJ.Text);
}
string strPJR = GetValue(new RICH.Common.BM.T_PM_UserInfo.T_PM_UserInfoApplicationLogicBase().GetValueByFixCondition("UserNickName", app.PJR, "UserID"));
if (!DataValidateManager.ValidateIsNull(strPJR))
{
app.PJR = strPJR;
}
if (!PJR.Text.IsHtmlNullOrWiteSpace())
{
app.PJR = Convert.ToString(PJR.Text);
}
if (!PJSJ.Text.IsHtmlNullOrWiteSpace())
{
app.PJSJ = Convert.ToDateTime(PJSJ.Text);
}
instanceT_BM_KCYYXXApplicationLogic.Add(app);
if (app.ResultCode == RICH.Common.Base.ApplicationData.ApplicationDataBase.ResultState.Succeed)
{
importCount++;
}
else
{
app.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.PK;
instanceT_BM_KCYYXXApplicationLogic.Modify(app);
if (app.ResultCode == RICH.Common.Base.ApplicationData.ApplicationDataBase.ResultState.Succeed)
{
updateCount++;
}
}
}
MessageContent += @"<font color=""green"">共{0}条数据，导入数据{1}条，更新数据{2}条。</font>".FormatInvariantCulture(totalCount, importCount, updateCount);
}
catch (Exception ex)
{
MessageContent += @"<font color=""red"">导入数据过程出错：{0}<br/>共{1}条数据，已导入数据{2}条，已更新数据{3}条。</font>".FormatInvariantCulture(ex.Message, totalCount, importCount, updateCount);
}
}