public DataSet GetNewsList(string strLMH, int intListNumber, string strXXZT = null, string strIsBest = null, string strXXLX = null)
{
appData = new T_BG_0601ApplicationData();
appData.CurrentPage = 1;
appData.PageSize = intListNumber;
appData.SortField = "IsTop DESC, TopSort ASC, FBSJRQ";
appData.Sort = false;
if (strIsBest != null)
{
appData.IsBest = strIsBest;
}
appData.FBLMBatch = GetSubColumn(strLMH);
if (strXXLX != null)
{
appData.XXLX = strXXLX;
}
if (strXXZT != null)
{
appData.XXZT = strXXZT;
}
T_BG_0601ApplicationLogic instanceT_BG_0601ApplicationLogic
= (T_BG_0601ApplicationLogic)CreateApplicationLogicInstance(typeof(T_BG_0601ApplicationLogic));
appData = instanceT_BG_0601ApplicationLogic.Query(appData);
return(appData.ResultSet);
}
public DataSet GetXXNR(string guidObjectID)
{
appData = new T_BG_0601ApplicationData();
appData.PageSize = 1;
appData.ObjectID = guidObjectID;
appData.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.ID;
T_BG_0601ApplicationLogic instanceT_BG_0601ApplicationLogic
= (T_BG_0601ApplicationLogic)CreateApplicationLogicInstance(typeof(T_BG_0601ApplicationLogic));
appData = instanceT_BG_0601ApplicationLogic.Query(appData);
return(appData.ResultSet);
}
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_BG_0601", dt, true, true);
T_BG_0601ApplicationLogic instanceT_BG_0601ApplicationLogic = (T_BG_0601ApplicationLogic)CreateApplicationLogicInstance(typeof(T_BG_0601ApplicationLogic));
foreach (DataRow dr in dt.Rows)
{
appData = new T_BG_0601ApplicationData();
appData.FBH = instanceT_BG_0601ApplicationLogic.AutoGenerateFBH(appData);
int i = 0;
appData = instanceT_BG_0601ApplicationLogic.Add(appData);
}
}
protected void btnInfoFromDS_Click(object sender, EventArgs e)
{
int totalCount = 0;
int importCount = 0;
int updateCount = 0;
try
{
var appDatas = T_BG_0601ApplicationData.GetDataFromDataFile <T_BG_0601ApplicationData>(InfoFromDoc.Text, true, true, recordStartLine: T_BG_0601Contants.ImportDataSetStartLineNum);
T_BG_0601ApplicationLogic instanceT_BG_0601ApplicationLogic = (T_BG_0601ApplicationLogic)CreateApplicationLogicInstance(typeof(T_BG_0601ApplicationLogic));
totalCount = appDatas.Count;
foreach (var app in appDatas)
{
app.FBH = instanceT_BG_0601ApplicationLogic.AutoGenerateFBH(app);
if (!BT.Text.IsHtmlNullOrWiteSpace())
{
app.BT = Convert.ToString(BT.Text);
}
string strFBLM = GetValue(new RICH.Common.BM.T_BG_0602.T_BG_0602ApplicationLogicBase().GetValueByFixCondition("LMM", app.FBLM, "LMH"));
if (!DataValidateManager.ValidateIsNull(strFBLM))
{
app.FBLM = strFBLM;
}
if (!FBLM.SelectedValue.IsHtmlNullOrWiteSpace())
{
app.FBLM = Convert.ToString(FBLM.SelectedValue);
}
string strFBBM = GetValue(new RICH.Common.BM.T_BM_DWXX.T_BM_DWXXApplicationLogicBase().GetValueByFixCondition("DWMC", app.FBBM, "DWBH"));
if (!DataValidateManager.ValidateIsNull(strFBBM))
{
app.FBBM = strFBBM;
}
if (!FBBM.SelectedValue.IsHtmlNullOrWiteSpace())
{
app.FBBM = Convert.ToString(FBBM.SelectedValue);
}
string strXXLX = GetValue(new RICH.Common.BM.Dictionary.DictionaryApplicationLogicBase().GetValueByFixCondition("MC", app.XXLX, "DM"));
if (!DataValidateManager.ValidateIsNull(strXXLX))
{
app.XXLX = strXXLX;
}
if (!XXLX.SelectedValue.IsHtmlNullOrWiteSpace())
{
app.XXLX = Convert.ToString(XXLX.SelectedValue);
}
if (!XXTPDZ.Text.IsHtmlNullOrWiteSpace())
{
app.XXTPDZ = Convert.ToString(XXTPDZ.Text);
}
if (!XXNR.Text.IsHtmlNullOrWiteSpace())
{
app.XXNR = Convert.ToString(XXNR.Text);
}
if (!FJXZDZ.Text.IsHtmlNullOrWiteSpace())
{
app.FJXZDZ = Convert.ToString(FJXZDZ.Text);
}
app.XXZT = "02";
string strXXZT = GetValue(new RICH.Common.BM.Dictionary.DictionaryApplicationLogicBase().GetValueByFixCondition("MC", app.XXZT, "DM"));
if (!DataValidateManager.ValidateIsNull(strXXZT))
{
app.XXZT = strXXZT;
}
string strIsTop = GetValue(new RICH.Common.BM.Dictionary.DictionaryApplicationLogicBase().GetValueByFixCondition("MC", app.IsTop, "DM"));
if (!DataValidateManager.ValidateIsNull(strIsTop))
{
app.IsTop = strIsTop;
}
if (!IsTop.SelectedValue.IsHtmlNullOrWiteSpace())
{
app.IsTop = Convert.ToString(IsTop.SelectedValue);
}
if (!TopSort.Text.IsHtmlNullOrWiteSpace())
{
app.TopSort = Convert.ToInt32(TopSort.Text);
}
string strIsBest = GetValue(new RICH.Common.BM.Dictionary.DictionaryApplicationLogicBase().GetValueByFixCondition("MC", app.IsBest, "DM"));
if (!DataValidateManager.ValidateIsNull(strIsBest))
{
app.IsBest = strIsBest;
}
if (!IsBest.SelectedValue.IsHtmlNullOrWiteSpace())
{
app.IsBest = Convert.ToString(IsBest.SelectedValue);
}
app.FBRJGH = (string)Session[ConstantsManager.SESSION_USER_ID];
string strFBRJGH = GetValue(new RICH.Common.BM.T_PM_UserInfo.T_PM_UserInfoApplicationLogicBase().GetValueByFixCondition("UserNickName", app.FBRJGH, "UserID"));
if (!DataValidateManager.ValidateIsNull(strFBRJGH))
{
app.FBRJGH = strFBRJGH;
}
app.FBSJRQ = DateTime.Now;
app.FBIP = (string)Request.ServerVariables["REMOTE_ADDR"];
instanceT_BG_0601ApplicationLogic.Add(app);
if (app.ResultCode == RICH.Common.Base.ApplicationData.ApplicationDataBase.ResultState.Succeed)
{
importCount++;
}
else
{
app.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.PK;
instanceT_BG_0601ApplicationLogic.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);
}
}
//=====================================================================
// FunctionName : GetAddInputParameter
/// <summary>
/// 得到添加用户输入参数操作
/// </summary>
//=====================================================================
protected override Boolean GetAddInputParameter()
{
Boolean boolReturn = true;
ValidateData validateData = new ValidateData();
// 验证输入参数
validateData = ValidateBT(BT.Text, false, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.BT = Convert.ToString(validateData.Value.ToString());
}
BT.BackColor = System.Drawing.Color.Empty;
}
else
{
BT.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
validateData = ValidateFBLM(FBLM.SelectedValue, false, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.FBLM = Convert.ToString(validateData.Value.ToString());
}
FBLM.BackColor = System.Drawing.Color.Empty;
}
else
{
FBLM.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
validateData = ValidateFBBM(FBBM.SelectedValue, true, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.FBBM = Convert.ToString(validateData.Value.ToString());
}
FBBM.BackColor = System.Drawing.Color.Empty;
}
else
{
FBBM.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
validateData = ValidateXXLX(XXLX.SelectedValue, false, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.XXLX = Convert.ToString(validateData.Value.ToString());
}
XXLX.BackColor = System.Drawing.Color.Empty;
}
else
{
XXLX.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
if (XXTPDZ.Upload())
{
appData.XXTPDZ = XXTPDZ.Text;
}
else
{
MessageContent += @"<font color=""red"">" + XXTPDZ.Message + "</font>";
boolReturn = false;
}
validateData = ValidateXXNR(XXNR.Text, false, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.XXNR = Convert.ToString(validateData.Value.ToString());
}
XXNR.BackColor = System.Drawing.Color.Empty;
}
else
{
XXNR.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
if (FJXZDZ.Upload())
{
appData.FJXZDZ = FJXZDZ.Text;
}
else
{
MessageContent += @"<font color=""red"">" + FJXZDZ.Message + "</font>";
boolReturn = false;
}
appData.XXZT = "02";
validateData = ValidateIsTop(IsTop.SelectedValue, true, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.IsTop = Convert.ToString(validateData.Value.ToString());
}
IsTop.BackColor = System.Drawing.Color.Empty;
}
else
{
IsTop.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
validateData = ValidateTopSort(TopSort.Text, true, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.TopSort = Convert.ToInt32(validateData.Value.ToString());
}
TopSort.BackColor = System.Drawing.Color.Empty;
}
else
{
TopSort.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
validateData = ValidateIsBest(IsBest.SelectedValue, true, false);
if (validateData.Result)
{
if (!validateData.IsNull)
{
appData.IsBest = Convert.ToString(validateData.Value.ToString());
}
IsBest.BackColor = System.Drawing.Color.Empty;
}
else
{
IsBest.BackColor = System.Drawing.Color.YellowGreen;
MessageContent += @"<font color=""red"">" + validateData.Message + "</font>";
boolReturn = validateData.Result;
}
appData.FBRJGH = (string)Session[ConstantsManager.SESSION_USER_ID];
appData.FBSJRQ = DateTime.Now;
appData.FBIP = (string)Request.ServerVariables["REMOTE_ADDR"];
// 自动生成编号
T_BG_0601ApplicationLogic instanceT_BG_0601ApplicationLogic
= (T_BG_0601ApplicationLogic)CreateApplicationLogicInstance(typeof(T_BG_0601ApplicationLogic));
appData.FBH = instanceT_BG_0601ApplicationLogic.AutoGenerateFBH(appData);
appData.XXZT = "02";
appData.FBRJGH = (string)Session[ConstantsManager.SESSION_USER_ID];
appData.FBSJRQ = DateTime.Now;
appData.FBIP = (string)Request.ServerVariables["REMOTE_ADDR"];
return(boolReturn);
}
