/// <summary>
/// 更新一条数据
/// </summary>
public void UpdateARMoneyInfo(ARMoneyInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbARMoneyInfo set ");
strSql.Append("ARObjID=@ARObjID,");
strSql.Append("ARObjType=@ARObjType,");
strSql.Append("aAMoney=@aAMoney,");
strSql.Append("aBMoney=@aBMoney,");
strSql.Append("aOpenDate=@aOpenDate,");
strSql.Append("aOpenMoney=@aOpenMoney,");
strSql.Append("aDate=@aDate,");
strSql.Append("aActualDate=@aActualDate,");
strSql.Append("aActualMoney=@aActualMoney,");
strSql.Append("aUpdateTime=@aUpdateTime,");
strSql.Append("aSteps=@aSteps,");
strSql.Append("aAppendTime=@aAppendTime,");
strSql.Append("aErpOrderIDStr=@aErpOrderIDStr");
strSql.Append(" where ARMoneyID=@ARMoneyID ");
SqlParameter[] parameters =
{
new SqlParameter("@ARMoneyID", SqlDbType.Int, 4),
new SqlParameter("@ARObjID", SqlDbType.Int, 4),
new SqlParameter("@ARObjType", SqlDbType.Int, 4),
new SqlParameter("@aAMoney", SqlDbType.Money, 8),
new SqlParameter("@aBMoney", SqlDbType.Money, 8),
new SqlParameter("@aOpenDate", SqlDbType.DateTime),
new SqlParameter("@aOpenMoney", SqlDbType.Money, 8),
new SqlParameter("@aDate", SqlDbType.DateTime),
new SqlParameter("@aActualDate", SqlDbType.DateTime),
new SqlParameter("@aActualMoney", SqlDbType.Money, 8),
new SqlParameter("@aUpdateTime", SqlDbType.DateTime),
new SqlParameter("@aSteps", SqlDbType.Int, 4),
new SqlParameter("@aAppendTime", SqlDbType.DateTime),
new SqlParameter("@aErpOrderIDStr", SqlDbType.NText)
};
parameters[0].Value = model.ARMoneyID;
parameters[1].Value = model.ARObjID;
parameters[2].Value = model.ARObjType;
parameters[3].Value = model.aAMoney;
parameters[4].Value = model.aBMoney;
parameters[5].Value = model.aOpenDate;
parameters[6].Value = model.aOpenMoney;
parameters[7].Value = model.aDate;
parameters[8].Value = model.aActualDate;
parameters[9].Value = model.aActualMoney;
parameters[10].Value = model.aUpdateTime;
parameters[11].Value = model.aSteps;
parameters[12].Value = model.aAppendTime;
parameters[13].Value = model.aErpOrderIDStr;
DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddARMoneyInfo(ARMoneyInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbARMoneyInfo(");
strSql.Append("ARObjID,ARObjType,aAMoney,aBMoney,aOpenDate,aOpenMoney,aDate,aActualDate,aActualMoney,aUpdateTime,aSteps,aAppendTime,aErpOrderIDStr)");
strSql.Append(" values (");
strSql.Append("@ARObjID,@ARObjType,@aAMoney,@aBMoney,@aOpenDate,@aOpenMoney,@aDate,@aActualDate,@aActualMoney,@aUpdateTime,@aSteps,@aAppendTime,@aErpOrderIDStr)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ARObjID", SqlDbType.Int, 4),
new SqlParameter("@ARObjType", SqlDbType.Int, 4),
new SqlParameter("@aAMoney", SqlDbType.Money, 8),
new SqlParameter("@aBMoney", SqlDbType.Money, 8),
new SqlParameter("@aOpenDate", SqlDbType.DateTime),
new SqlParameter("@aOpenMoney", SqlDbType.Money, 8),
new SqlParameter("@aDate", SqlDbType.DateTime),
new SqlParameter("@aActualDate", SqlDbType.DateTime),
new SqlParameter("@aActualMoney", SqlDbType.Money, 8),
new SqlParameter("@aUpdateTime", SqlDbType.DateTime),
new SqlParameter("@aSteps", SqlDbType.Int, 4),
new SqlParameter("@aAppendTime", SqlDbType.DateTime),
new SqlParameter("@aErpOrderIDStr", SqlDbType.NText)
};
parameters[0].Value = model.ARObjID;
parameters[1].Value = model.ARObjType;
parameters[2].Value = model.aAMoney;
parameters[3].Value = model.aBMoney;
parameters[4].Value = model.aOpenDate;
parameters[5].Value = model.aOpenMoney;
parameters[6].Value = model.aDate;
parameters[7].Value = model.aActualDate;
parameters[8].Value = model.aActualMoney;
parameters[9].Value = model.aUpdateTime;
parameters[10].Value = model.aSteps;
parameters[11].Value = model.aAppendTime;
parameters[12].Value = model.aErpOrderIDStr;
object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(-1);
}
else
{
return(Convert.ToInt32(obj));
}
}
public static void DeleteARMoneyInfo(string ARMoneyID)
{
if (ARMoneyID.Trim() != "")
{
ARMoneyID = "," + ARMoneyID + ",";
ARMoneyID = Utils.ReSQLSetTxt(ARMoneyID);
//修改单据对账状态
string[] ARMoneyIDArray = Utils.SplitString(ARMoneyID, ",");
if (ARMoneyIDArray.Length > 0)
{
ARMoneyInfo ari = new ARMoneyInfo();
try
{
foreach (string _ARMoneyID in ARMoneyIDArray)
{
if (_ARMoneyID.Trim() != "")
{
ari = GetARMoneyInfoModel(Utils.StrToInt(_ARMoneyID.Trim(), 0));
if (ari != null)
{
if (ari.aErpOrderIDStr.Trim() != "")
{
ari.aErpOrderIDStr = "," + ari.aErpOrderIDStr + ",";
ari.aErpOrderIDStr = Utils.ReSQLSetTxt(ari.aErpOrderIDStr);
tbErpOrderInfo.UpdateErpOrderIsCheck(ari.aErpOrderIDStr, 0);
}
}
}
}
}
finally {
ari = null;
}
}
DatabaseProvider.GetInstance().DeleteARMoneyInfo(ARMoneyID);
}
}
public static void UpdateARMoneyInfo(ARMoneyInfo model)
{
DatabaseProvider.GetInstance().UpdateARMoneyInfo(model);
}
public static int AddARMoneyInfo(ARMoneyInfo model)
{
return(DatabaseProvider.GetInstance().AddARMoneyInfo(model));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ARMoneyInfo GetARMoneyInfoModel(int ARMoneyID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ARMoneyID,ARObjID,ARObjType,aAMoney,aBMoney,aOpenDate,aOpenMoney,aDate,aActualDate,aActualMoney,aUpdateTime,aSteps,aAppendTime,aErpOrderIDStr," +
"(CASE ARObjType " +
" when 0 then dbo.fun_GetNameForObjID(ARObjID,0) " +
" when 1 then dbo.fun_GetNameForObjID(ARObjID,1) " +
" when 2 then dbo.fun_GetNameForObjID(ARObjID,3) " +
"end) as ARObjName from tbARMoneyInfo ");
strSql.Append(" where ARMoneyID=@ARMoneyID ");
SqlParameter[] parameters =
{
new SqlParameter("@ARMoneyID", SqlDbType.Int, 4)
};
parameters[0].Value = ARMoneyID;
ARMoneyInfo model = new ARMoneyInfo();
DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ARMoneyID"].ToString() != "")
{
model.ARMoneyID = int.Parse(ds.Tables[0].Rows[0]["ARMoneyID"].ToString());
}
if (ds.Tables[0].Rows[0]["ARObjID"].ToString() != "")
{
model.ARObjID = int.Parse(ds.Tables[0].Rows[0]["ARObjID"].ToString());
}
if (ds.Tables[0].Rows[0]["ARObjType"].ToString() != "")
{
model.ARObjType = int.Parse(ds.Tables[0].Rows[0]["ARObjType"].ToString());
}
model.ARObjName = ds.Tables[0].Rows[0]["ARObjName"].ToString();
model.aErpOrderIDStr = ds.Tables[0].Rows[0]["aErpOrderIDStr"].ToString();
if (ds.Tables[0].Rows[0]["aAMoney"].ToString() != "")
{
model.aAMoney = decimal.Parse(ds.Tables[0].Rows[0]["aAMoney"].ToString());
}
if (ds.Tables[0].Rows[0]["aBMoney"].ToString() != "")
{
model.aBMoney = decimal.Parse(ds.Tables[0].Rows[0]["aBMoney"].ToString());
}
if (ds.Tables[0].Rows[0]["aOpenDate"].ToString() != "")
{
model.aOpenDate = DateTime.Parse(ds.Tables[0].Rows[0]["aOpenDate"].ToString());
}
if (ds.Tables[0].Rows[0]["aOpenMoney"].ToString() != "")
{
model.aOpenMoney = decimal.Parse(ds.Tables[0].Rows[0]["aOpenMoney"].ToString());
}
if (ds.Tables[0].Rows[0]["aDate"].ToString() != "")
{
model.aDate = DateTime.Parse(ds.Tables[0].Rows[0]["aDate"].ToString());
}
if (ds.Tables[0].Rows[0]["aActualDate"].ToString() != "")
{
model.aActualDate = DateTime.Parse(ds.Tables[0].Rows[0]["aActualDate"].ToString());
}
if (ds.Tables[0].Rows[0]["aActualMoney"].ToString() != "")
{
model.aActualMoney = decimal.Parse(ds.Tables[0].Rows[0]["aActualMoney"].ToString());
}
if (ds.Tables[0].Rows[0]["aUpdateTime"].ToString() != "")
{
model.aUpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["aUpdateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["aSteps"].ToString() != "")
{
model.aSteps = int.Parse(ds.Tables[0].Rows[0]["aSteps"].ToString());
}
if (ds.Tables[0].Rows[0]["aAppendTime"].ToString() != "")
{
model.aAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["aAppendTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("6-3"))
{
Act = HTTPRequest.GetString("Act");
if (Act == "Edit")
{
ARMoneyID = Utils.StrToInt(HTTPRequest.GetString("aid"), 0);
ai = tbARMoneyInfo.GetARMoneyInfoModel(ARMoneyID);
}
if (ispost)
{
ARObjID = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("ARObjID")), 0);
ARObjType = Utils.StrToInt(HTTPRequest.GetString("ARObjType"), 0);
aAMoney = decimal.Parse(HTTPRequest.GetString("aAMoney").Trim());
aBMoney = decimal.Parse(HTTPRequest.GetString("aBMoney").Trim());
aSteps = HTTPRequest.GetInt("aSteps", 1);
if (HTTPRequest.GetString("aOpenDate").Trim() != "")
{
aOpenDate = DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("aOpenDate")));
}
aOpenMoney = decimal.Parse(HTTPRequest.GetString("aOpenMoney"));
if (HTTPRequest.GetString("aDate").Trim() != "")
{
aDate = DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("aDate")));
}
if (HTTPRequest.GetString("aActualDate").Trim() != "")
{
aActualDate = DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("aActualDate")));
}
aActualMoney = decimal.Parse(HTTPRequest.GetString("aActualMoney").Trim());
if (ARObjID > 0)
{
//if (aAMoney > 0)
{
ai.ARObjID = ARObjID;
ai.ARObjType = ARObjType;
ai.aAMoney = aAMoney;
ai.aBMoney = aBMoney;
ai.aOpenDate = aOpenDate;
ai.aOpenMoney = aOpenMoney;
ai.aDate = aDate;
if (Act == "Add")
{
ai.aActualDate = aActualDate;
ai.aActualMoney = aActualMoney;
ai.aUpdateTime = DateTime.Now;
ai.aSteps = aSteps;
ai.aAppendTime = DateTime.Now;
if (tbARMoneyInfo.AddARMoneyInfo(ai) > 0)
{
AddMsgLine("创建成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
else
{
AddErrLine("创建失败!");
AddScript("window.setTimeout('history.back(1);',3000);");
}
}
if (Act == "Edit")
{
try
{
ai.aActualDate = aActualDate;
ai.aActualMoney = aActualMoney;
ai.aUpdateTime = DateTime.Now;
ai.aSteps = aSteps;
tbARMoneyInfo.UpdateARMoneyInfo(ai);
AddMsgLine("修改成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("修改失败!<br/>" + ex);
AddScript("window.setTimeout('window.parent.HidBox();',3000);");
}
}
}
// else
{
// AddErrLine("请填写发生金额!");
// AddScript("window.setTimeout('history.back(1);',1000);");
}
}
else
{
AddErrLine("请选择应收对象!");
AddScript("window.setTimeout('history.back(1);',2000);");
}
}
else
{
if (Act == "Del")
{
try
{
tbARMoneyInfo.DeleteARMoneyInfo(HTTPRequest.GetString("aid"));
AddMsgLine("删除成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("删除失败!<br/>" + ex);
AddScript("window.setTimeout('window.parent.HidBox();',3000);");
}
}
}
}
else
{
AddErrLine("权限不足!");
AddScript("window.setTimeout('window.parent.HidBox();',2000);");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
Act = HTTPRequest.GetString("Act");
if (ispost)
{
//if (Act == "Search")
{
if (HTTPRequest.GetString("bDate").Trim() != "")
{
bDate = DateTime.Parse(HTTPRequest.GetString("bDate").Trim() + " 00:00:00");
}
if (HTTPRequest.GetString("eDate").Trim() != "")
{
eDate = DateTime.Parse(HTTPRequest.GetString("eDate").Trim() + " 23:59:59");
}
}
if (Act == "OK")
{
loop_count = HTTPRequest.GetInt("loop_count", 0);
if (loop_count > 0)
{
int StoresID = 0;
decimal tMoney = 0;
decimal nMoney = 0;
ARMoneyInfo ar = new ARMoneyInfo();
string odIDStr = "";
int tCount = 0;
for (int i = 0; i < loop_count; i++)
{
StoresID = HTTPRequest.GetInt("_StoresID_" + i, 0);
if (StoresID > 0)
{
tMoney = decimal.Parse(HTTPRequest.GetString("_tMoney_" + i).ToString());
nMoney = decimal.Parse(HTTPRequest.GetString("_nMoney_" + i).ToString());
ar.ARObjID = StoresID;
ar.ARObjType = 0;
ar.aAMoney = nMoney;
ar.aBMoney = tMoney;
ar.aOpenDate = DateTime.Now;
ar.aOpenMoney = tMoney;
ar.aDate = DateTime.Now;
ar.aActualDate = DateTime.Now;
ar.aActualMoney = 0;
ar.aUpdateTime = DateTime.Now;
ar.aSteps = 1;
ar.aAppendTime = DateTime.Now;
ar.ARMoneyID = tbARMoneyInfo.AddARMoneyInfo(ar);
if (ar.ARMoneyID > 0)
{
//给单据打标记,标明为"已对账"
//取出该客户门店下所有指定订单编号
odIDStr = tbErpOrderInfo.GetErpOrderIDStr(ar.ARObjID, 1, eDate); //发货
odIDStr = odIDStr + "," + tbErpOrderInfo.GetErpOrderIDStr(ar.ARObjID, 5, eDate); //退货
ar.aErpOrderIDStr = odIDStr;
try
{
tbErpOrderInfo.UpdateErpOrderCheck(ar.ARObjID, 1, eDate, 1); //发货
tbErpOrderInfo.UpdateErpOrderCheck(ar.ARObjID, 5, eDate, 1); //退货
tbARMoneyInfo.UpdateARMoneyInfo(ar);
}
catch
{
}
tCount++;
}
}
}
AddMsgLine("导入成功,共导入 <b>" + tCount + "</b> 家客户,门店应收数据!");
AddScript("window.setTimeout('window.parent.HidBox();',3000);");
}
}
}
dList = tbARMoneyInfo.GetErpCustomerPay("", "", bDate, eDate);
if (dList != null)
{
dList.Columns.Add("tMoney", typeof(decimal));
dList.Columns.Add("nMoney", typeof(decimal));
foreach (DataRow dr in dList.Rows)
{
//实际应收
dr["tMoney"] = decimal.Parse(dr["sDoDayMoney"].ToString()) + (decimal.Parse(dr["DeliveryMoney"].ToString()) - decimal.Parse(dr["ReturnMoney"].ToString())) + (decimal.Parse(dr["AMoney"].ToString()) - decimal.Parse(dr["ActualMoney"].ToString()));
//新增应收
dr["nMoney"] = decimal.Parse(dr["DeliveryMoney"].ToString()) - decimal.Parse(dr["ReturnMoney"].ToString());
}
}
DataView dv = dList.DefaultView;
dv.Sort = "tMoney desc";
dList = dv.ToTable();
/*
* if (Act == "OK")
* {
* ARMoneyInfo ar = new ARMoneyInfo();
* string odIDStr = "";
* int tCount = 0;
*
* foreach (DataRow dr2 in dList.Rows)
* {
* if (decimal.Parse(dr2["nMoney"].ToString()) != 0 )
* {
* odIDStr = "";
*
* ar.ARObjID = int.Parse(dr2["StoresID"].ToString());
* ar.ARObjType = 0;
* ar.aAMoney = decimal.Parse(dr2["nMoney"].ToString());
* ar.aBMoney = decimal.Parse(dr2["tMoney"].ToString());
* ar.aOpenDate = DateTime.Now;
* ar.aOpenMoney = decimal.Parse(dr2["tMoney"].ToString());
* ar.aDate = DateTime.Now;
* ar.aActualDate = DateTime.Now;
* ar.aActualMoney = decimal.Parse(dr2["tMoney"].ToString());
* ar.aUpdateTime = DateTime.Now;
* ar.aSteps = 0;
* ar.aAppendTime = DateTime.Now;
*
* ar.ARMoneyID = tbARMoneyInfo.AddARMoneyInfo(ar);
*
* if (ar.ARMoneyID > 0)
* {
* //给单据打标记,标明为"已对账"
* //取出该客户门店下所有指定订单编号
* odIDStr = tbErpOrderInfo.GetErpOrderIDStr(ar.ARObjID, 1, eDate);//发货
* odIDStr = odIDStr +","+ tbErpOrderInfo.GetErpOrderIDStr(ar.ARObjID, 5, eDate);//退货
* ar.aErpOrderIDStr = odIDStr;
*
* try
* {
* tbErpOrderInfo.UpdateErpOrderCheck(ar.ARObjID, 1, eDate, 1);//发货
* tbErpOrderInfo.UpdateErpOrderCheck(ar.ARObjID, 5, eDate, 1);//退货
*
* tbARMoneyInfo.UpdateARMoneyInfo(ar);
* }
* catch
* {
*
* }
* tCount++;
* }
* }
* }
* AddMsgLine("导入成功,共导入 <b>" + tCount + "</b> 家客户,门店应收数据!");
* AddScript("window.setTimeout('window.parent.HidBox();',3000);");
* }
*/
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("6-3"))
{
Act = HTTPRequest.GetString("Act");
if (ispost)
{
if (Act == "OK")
{
eDate = DateTime.Parse(HTTPRequest.GetString("eDate"));
loop_count = HTTPRequest.GetInt("loop_count_obj", 0);
if (loop_count > 0)
{
int ARObjID = 0;
DateTime aOpenDate = DateTime.Now;
decimal aOpenMoney = 0;
DateTime aDate = DateTime.Now;
DateTime aActualDate = DateTime.Now;
decimal aAMoney = 0;
decimal aBMoney = 0;
decimal aActualMoney = 0;
ARObjType = HTTPRequest.GetInt("ARObjType", 0);
ARMoneyInfo ar = new ARMoneyInfo();
int tCount = 0;
string odIDStr = "";
for (int i = 0; i < loop_count; i++)
{
ARObjID = HTTPRequest.GetInt("ARObjID_" + i, 0);
if (ARObjID > 0)
{
aAMoney = decimal.Parse(HTTPRequest.GetString("aAMoney_" + i).ToString());
aBMoney = decimal.Parse(HTTPRequest.GetString("aBMoney_" + i).ToString());
aOpenMoney = decimal.Parse(HTTPRequest.GetString("aOpenMoney_" + i).ToString());
aActualMoney = decimal.Parse(HTTPRequest.GetString("aActualMoney_" + i).ToString());
aOpenDate = HTTPRequest.GetString("aOpenDate_" + i).Trim() != "" ? DateTime.Parse(HTTPRequest.GetString("aOpenDate_" + i).Trim()) : DateTime.Now;
aDate = HTTPRequest.GetString("aDate_" + i).Trim() != "" ? DateTime.Parse(HTTPRequest.GetString("aDate_" + i).Trim()) : DateTime.Now;
aActualDate = HTTPRequest.GetString("aActualDate_" + i).Trim() != "" ? DateTime.Parse(HTTPRequest.GetString("aActualDate_" + i).Trim()) : DateTime.Now;
ar.ARObjID = ARObjID;
ar.ARObjType = ARObjType;
ar.aAMoney = aAMoney;
ar.aBMoney = aBMoney;
ar.aOpenDate = aOpenDate;
ar.aOpenMoney = aOpenMoney;
ar.aDate = aDate;
ar.aActualDate = aActualDate;
ar.aActualMoney = aActualMoney;
ar.aUpdateTime = DateTime.Now;
ar.aSteps = 1;
ar.aAppendTime = DateTime.Now;
ar.ARMoneyID = tbARMoneyInfo.AddARMoneyInfo(ar);
if (ar.ARMoneyID > 0) //更新,订单状态,并保留操作编号
{
if (ARObjType == 0) //非结算系统
{
//给单据打标记,标明为"已对账"
//取出该客户门店下所有指定订单编号
odIDStr = tbErpOrderInfo.GetErpOrderIDStr(ar.ARObjID, 1, eDate); //发货
odIDStr = odIDStr + "," + tbErpOrderInfo.GetErpOrderIDStr(ar.ARObjID, 5, eDate); //退货
ar.aErpOrderIDStr = odIDStr;
try
{
tbErpOrderInfo.UpdateErpOrderCheck(ar.ARObjID, 1, eDate, 1); //发货
tbErpOrderInfo.UpdateErpOrderCheck(ar.ARObjID, 5, eDate, 1); //退货
tbARMoneyInfo.UpdateARMoneyInfo(ar);
}
catch
{
}
}
else if (ARObjType == 2)//结算系统
{
DataTable _pDataList = tbStoresInfo.GetStoresInfoList(" PaymentSystemID=" + ar.ARObjID + "").Tables[0];
try
{
if (_pDataList != null)
{
foreach (DataRow dr in _pDataList.Rows)
{
odIDStr = odIDStr + "," + tbErpOrderInfo.GetErpOrderIDStr(int.Parse(dr["StoresID"].ToString()), 1, eDate); //发货
odIDStr = odIDStr + "," + tbErpOrderInfo.GetErpOrderIDStr(int.Parse(dr["StoresID"].ToString()), 5, eDate); //退货
tbErpOrderInfo.UpdateErpOrderCheck(int.Parse(dr["StoresID"].ToString()), 1, eDate, 1); //发货
tbErpOrderInfo.UpdateErpOrderCheck(int.Parse(dr["StoresID"].ToString()), 5, eDate, 1); //退货
}
ar.aErpOrderIDStr = odIDStr;
try
{
tbARMoneyInfo.UpdateARMoneyInfo(ar);
}
catch
{
}
}
}
finally
{
_pDataList.Clear();
}
}
tCount++;
}
}
}
AddMsgLine("导入成功,共导入 <b>" + tCount + "</b> 条应收数据!");
AddScript("window.setTimeout('window.parent.HidBox();',3000);");
}
else
{
AddErrLine("没有任何数据插入!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
}
}
else
{
AddErrLine("权限不足!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
