/// <summary>
/// 更新一条数据
/// </summary>
public void UpdateAPMoneyInfo(APMoneyInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbAPMoneyInfo set ");
strSql.Append("APObjID=@APObjID,");
strSql.Append("APObjType=@APObjType,");
strSql.Append("aPMoney=@aPMoney,");
strSql.Append("aPayMoney=@aPayMoney,");
strSql.Append("aOtherMoney=@aOtherMoney,");
strSql.Append("aReMake=@aReMake,");
strSql.Append("aDoDateTime=@aDoDateTime,");
strSql.Append("aAppendTime=@aAppendTime,");
strSql.Append("FeesSubjectID=@FeesSubjectID,");
strSql.Append("aErpOrderIDStr=@aErpOrderIDStr,");
strSql.Append("aNPMoney=@aNPMoney");
strSql.Append(" where APMoneyID=@APMoneyID ");
SqlParameter[] parameters =
{
new SqlParameter("@APMoneyID", SqlDbType.Int, 4),
new SqlParameter("@APObjID", SqlDbType.Int, 4),
new SqlParameter("@APObjType", SqlDbType.Int, 4),
new SqlParameter("@aPMoney", SqlDbType.Money, 8),
new SqlParameter("@aPayMoney", SqlDbType.Money, 8),
new SqlParameter("@aOtherMoney", SqlDbType.Money, 8),
new SqlParameter("@aReMake", SqlDbType.VarChar, 256),
new SqlParameter("@aDoDateTime", SqlDbType.DateTime),
new SqlParameter("@aAppendTime", SqlDbType.DateTime),
new SqlParameter("@FeesSubjectID", SqlDbType.Int, 4),
new SqlParameter("@aErpOrderIDStr", SqlDbType.NText),
new SqlParameter("@aNPMoney", SqlDbType.Money, 8)
};
parameters[0].Value = model.APMoneyID;
parameters[1].Value = model.APObjID;
parameters[2].Value = model.APObjType;
parameters[3].Value = model.aPMoney;
parameters[4].Value = model.aPayMoney;
parameters[5].Value = model.aOtherMoney;
parameters[6].Value = model.aReMake;
parameters[7].Value = model.aDoDateTime;
parameters[8].Value = model.aAppendTime;
parameters[9].Value = model.FeesSubjectID;
parameters[10].Value = model.aErpOrderIDStr;
parameters[11].Value = model.aNPMoney;
DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddAPMoneyInfo(APMoneyInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbAPMoneyInfo(");
strSql.Append("APObjID,APObjType,aPMoney,aPayMoney,aOtherMoney,aReMake,aDoDateTime,aAppendTime,FeesSubjectID,aErpOrderIDStr,aNPMoney)");
strSql.Append(" values (");
strSql.Append("@APObjID,@APObjType,@aPMoney,@aPayMoney,@aOtherMoney,@aReMake,@aDoDateTime,@aAppendTime,@FeesSubjectID,@aErpOrderIDStr,@aNPMoney)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@APObjID", SqlDbType.Int, 4),
new SqlParameter("@APObjType", SqlDbType.Int, 4),
new SqlParameter("@aPMoney", SqlDbType.Money, 8),
new SqlParameter("@aPayMoney", SqlDbType.Money, 8),
new SqlParameter("@aOtherMoney", SqlDbType.Money, 8),
new SqlParameter("@aReMake", SqlDbType.VarChar, 256),
new SqlParameter("@aDoDateTime", SqlDbType.DateTime),
new SqlParameter("@aAppendTime", SqlDbType.DateTime),
new SqlParameter("@FeesSubjectID", SqlDbType.Int, 4),
new SqlParameter("@aErpOrderIDStr", SqlDbType.NText),
new SqlParameter("@aNPMoney", SqlDbType.Money, 8),
};
parameters[0].Value = model.APObjID;
parameters[1].Value = model.APObjType;
parameters[2].Value = model.aPMoney;
parameters[3].Value = model.aPayMoney;
parameters[4].Value = model.aOtherMoney;
parameters[5].Value = model.aReMake;
parameters[6].Value = model.aDoDateTime;
parameters[7].Value = model.aAppendTime;
parameters[8].Value = model.FeesSubjectID;
parameters[9].Value = model.aErpOrderIDStr;
parameters[10].Value = model.aNPMoney;
object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(-1);
}
else
{
return(Convert.ToInt32(obj));
}
}
public static void DeleteAPMoneyInfo(string APMoneyID)
{
if (APMoneyID.Trim() != "")
{
APMoneyID = "," + APMoneyID + ",";
APMoneyID = Utils.ReSQLSetTxt(APMoneyID);
//修改单据对账状态
string[] APMoneyIDArray = Utils.SplitString(APMoneyID, ",");
if (APMoneyIDArray.Length > 0)
{
APMoneyInfo api = new APMoneyInfo();
try
{
foreach (string _APMoneyID in APMoneyIDArray)
{
if (_APMoneyID.Trim() != "")
{
api = GetAPMoneyInfoModel(Utils.StrToInt(_APMoneyID.Trim(), 0));
if (api != null)
{
if (api.aErpOrderIDStr.Trim() != "")
{
api.aErpOrderIDStr = "," + api.aErpOrderIDStr + ",";
api.aErpOrderIDStr = Utils.ReSQLSetTxt(api.aErpOrderIDStr);
tbErpOrderInfo.UpdateErpOrderIsCheck(api.aErpOrderIDStr, 0);
}
}
}
}
}
finally
{
api = null;
}
}
DatabaseProvider.GetInstance().DeleteAPMoneyInfo(APMoneyID);
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("6-4"))
{
Act = HTTPRequest.GetString("Act");
if (Act == "Edit")
{
APMoneyID = Utils.StrToInt(HTTPRequest.GetString("aid"), 0);
ai = tbAPMoneyInfo.GetAPMoneyInfoModel(APMoneyID);
}
if (ispost)
{
APObjID = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("APObjID")), 0);
APObjType = Utils.StrToInt(HTTPRequest.GetString("APObjType"), 0);
aPMoney = decimal.Parse(HTTPRequest.GetString("aPMoney"));
aPayMoney = decimal.Parse(HTTPRequest.GetString("aPayMoney"));
aNPMoney = decimal.Parse(HTTPRequest.GetString("aNPMoney"));
FeesSubjectID = Utils.StrToInt(HTTPRequest.GetString("FeesSubjectID"), 0);
aReMake = Utils.ChkSQL(HTTPRequest.GetString("aReMake"));
aDoDateTime = DateTime.Parse(HTTPRequest.GetString("aDoDateTime"));
if (APObjID > 0)
{
ai.APObjID = APObjID;
ai.APObjType = APObjType;
ai.aPMoney = aPMoney;
ai.aPayMoney = aPayMoney;
ai.aOtherMoney = aOtherMoney;
ai.FeesSubjectID = FeesSubjectID;
ai.aNPMoney = aNPMoney;
ai.aReMake = aReMake;
ai.aDoDateTime = aDoDateTime;
if (Act == "Add")
{
ai.aAppendTime = DateTime.Now;
if (tbAPMoneyInfo.AddAPMoneyInfo(ai) > 0)
{
AddMsgLine("创建成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
else
{
AddErrLine("创建失败!");
AddScript("window.setTimeout('history.back(1);',1000);");
}
}
if (Act == "Edit")
{
try
{
tbAPMoneyInfo.UpdateAPMoneyInfo(ai);
AddMsgLine("修改成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("修改失败!<br/>" + ex);
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
}
else
{
AddErrLine("请选择应付对象!");
AddScript("window.setTimeout('history.back(1);',1000);");
}
}
else
{
if (Act == "Del")
{
try
{
tbAPMoneyInfo.DeleteAPMoneyInfo(HTTPRequest.GetString("aid"));
AddMsgLine("删除成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("删除失败!<br/>" + ex);
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()));
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
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 SupplierID = 0;
APMoneyInfo ap = new APMoneyInfo();
string odIDStr = "";
int tCount = 0;
decimal nMoney = 0;
decimal tMoney = 0;
for (int i = 0; i < loop_count; i++)
{
SupplierID = HTTPRequest.GetInt("_SupplierID_" + i, 0);
if (SupplierID > 0)
{
nMoney = decimal.Parse(HTTPRequest.GetString("_nMoney_" + i).ToString());
tMoney = decimal.Parse(HTTPRequest.GetString("_tMoney_" + i).ToString());
odIDStr = "";
ap.APObjID = SupplierID;
ap.APObjType = 2;
ap.aPMoney = nMoney;
ap.aPayMoney = tMoney;
ap.aOtherMoney = 0;
ap.FeesSubjectID = 0;
ap.aReMake = "";
ap.aDoDateTime = DateTime.Now;
ap.aAppendTime = DateTime.Now;
ap.APMoneyID = tbAPMoneyInfo.AddAPMoneyInfo(ap);
if (ap.APMoneyID > 0)
{
//给单据打标记,标明为"已对账"
//取出该供货商下所有指定订单编号
odIDStr = tbErpOrderInfo.GetErpOrderIDStr(ap.APObjID, 4, eDate); //入库
odIDStr = odIDStr + "," + tbErpOrderInfo.GetErpOrderIDStr(ap.APObjID, 8, eDate); //退货
ap.aErpOrderIDStr = odIDStr;
try
{
tbErpOrderInfo.UpdateErpOrderCheck(ap.APObjID, 4, eDate, 1); //发货
tbErpOrderInfo.UpdateErpOrderCheck(ap.APObjID, 8, eDate, 1); //退货
tbAPMoneyInfo.UpdateAPMoneyInfo(ap);
}
catch
{
}
tCount++;
}
}
}
AddMsgLine("导入成功,共导入 <b>" + tCount + "</b> 家客户,门店应收数据!");
AddScript("window.setTimeout('window.parent.HidBox();',3000);");
}
}
}
dList = tbAPMoneyInfo.GetErpWillPay(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")
* {
* APMoneyInfo ap = new APMoneyInfo();
* string odIDStr = "";
* int tCount = 0;
*
* foreach (DataRow dr2 in dList.Rows)
* {
* if (decimal.Parse(dr2["nMoney"].ToString()) != 0)
* {
* odIDStr = "";
*
* ap.APObjID = int.Parse(dr2["SupplierID"].ToString());
* ap.APObjType = 0;
* ap.aPMoney = decimal.Parse(dr2["nMoney"].ToString());
* ap.aPayMoney = 0;
* ap.aOtherMoney = 0;
* ap.FeesSubjectID = 0;
* ap.aReMake = "";
* ap.aDoDateTime = DateTime.Now;
* ap.aAppendTime = DateTime.Now;
*
*
* ap.APMoneyID = tbAPMoneyInfo.AddAPMoneyInfo(ap);
*
* if (ap.APMoneyID > 0)
* {
* //给单据打标记,标明为"已对账"
* //取出该供货商下所有指定订单编号
* odIDStr = tbErpOrderInfo.GetErpOrderIDStr(ap.APObjID, 4, eDate);//入库
* odIDStr = odIDStr + "," + tbErpOrderInfo.GetErpOrderIDStr(ap.APObjID, 8, eDate);//退货
* ap.aErpOrderIDStr = odIDStr;
*
* try
* {
* tbErpOrderInfo.UpdateErpOrderCheck(ap.APObjID, 4, eDate, 1);//发货
* tbErpOrderInfo.UpdateErpOrderCheck(ap.APObjID, 8, eDate, 1);//退货
*
* tbAPMoneyInfo.UpdateAPMoneyInfo(ap);
* }
* catch
* {
*
* }
* tCount++;
* }
* }
* }
* AddMsgLine("导入成功,共导入 <b>" + tCount + "</b> 家客户,门店应收数据!");
* AddScript("window.setTimeout('window.parent.HidBox();',3000);");
* }
*/
}
public static void UpdateAPMoneyInfo(APMoneyInfo model)
{
DatabaseProvider.GetInstance().UpdateAPMoneyInfo(model);
}
public static int AddAPMoneyInfo(APMoneyInfo model)
{
return(DatabaseProvider.GetInstance().AddAPMoneyInfo(model));
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("6-4"))
{
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)
{
APObjType = HTTPRequest.GetInt("APObjType", 0);
int tCount = 0;
APMoneyInfo ap = new APMoneyInfo();
int APObjID = 0;
decimal nMoney = 0;
decimal tMoney = 0;
decimal aPayMoney = 0;
int FeesSubjectID = 0;
string odIDStr = "";
DateTime aDoDateTime = DateTime.Now;
for (int i = 0; i < loop_count; i++)
{
APObjID = HTTPRequest.GetInt("APObjID_" + i, 0);
if (APObjID > 0)
{
nMoney = decimal.Parse(HTTPRequest.GetString("nMoney_" + i).ToString());
tMoney = decimal.Parse(HTTPRequest.GetString("tMoney_" + i).ToString());
aPayMoney = decimal.Parse(HTTPRequest.GetString("aPayMoney_" + i).ToString());
aDoDateTime = HTTPRequest.GetString("aDoDateTime_" + i).Trim() != "" ? DateTime.Parse(HTTPRequest.GetString("aDoDateTime_" + i).Trim()) : DateTime.Now;
FeesSubjectID = HTTPRequest.GetInt("FeesSubjectID_" + i, 0);
ap.APObjID = APObjID;
ap.APObjType = APObjType;
ap.aNPMoney = nMoney;
ap.aPMoney = tMoney;
ap.aPayMoney = aPayMoney;
ap.aOtherMoney = 0;
ap.FeesSubjectID = FeesSubjectID;
ap.aReMake = "";
ap.aDoDateTime = aDoDateTime;
ap.aAppendTime = DateTime.Now;
ap.APMoneyID = tbAPMoneyInfo.AddAPMoneyInfo(ap);
if (ap.APMoneyID > 0)
{
//给单据打标记,标明为"已对账"
//取出该供货商下所有指定订单编号
odIDStr = tbErpOrderInfo.GetErpOrderIDStr(ap.APObjID, 4, eDate); //入库
odIDStr = odIDStr + "," + tbErpOrderInfo.GetErpOrderIDStr(ap.APObjID, 8, eDate); //退货
ap.aErpOrderIDStr = odIDStr;
try
{
tbErpOrderInfo.UpdateErpOrderCheck(ap.APObjID, 4, eDate, 1); //发货
tbErpOrderInfo.UpdateErpOrderCheck(ap.APObjID, 8, eDate, 1); //退货
tbAPMoneyInfo.UpdateAPMoneyInfo(ap);
}
catch
{
}
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()));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public APMoneyInfo GetAPMoneyInfoModel(int APMoneyID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 APMoneyID,APObjID,APObjType,aPMoney,aPayMoney,aOtherMoney,aReMake,aDoDateTime,aAppendTime,FeesSubjectID,aErpOrderIDStr,aNPMoney," +
"(CASE APObjType " +
" when 0 then dbo.fun_GetNameForObjID(APObjID,0) " +
" when 1 then dbo.fun_GetNameForObjID(APObjID,1) " +
" when 2 then dbo.fun_GetNameForObjID(APObjID,2) " +
"end) as APObjName,(select tbFeesSubjectInfo.fName from tbFeesSubjectInfo where tbFeesSubjectInfo.FeesSubjectID=tbAPMoneyInfo.[FeesSubjectID]) as FeesSubjectName from tbAPMoneyInfo ");
strSql.Append(" where APMoneyID=@APMoneyID ");
SqlParameter[] parameters =
{
new SqlParameter("@APMoneyID", SqlDbType.Int, 4)
};
parameters[0].Value = APMoneyID;
APMoneyInfo model = new APMoneyInfo();
DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["APMoneyID"].ToString() != "")
{
model.APMoneyID = int.Parse(ds.Tables[0].Rows[0]["APMoneyID"].ToString());
}
if (ds.Tables[0].Rows[0]["APObjID"].ToString() != "")
{
model.APObjID = int.Parse(ds.Tables[0].Rows[0]["APObjID"].ToString());
}
model.APObjName = ds.Tables[0].Rows[0]["APObjName"].ToString();
model.FeesSubjectName = ds.Tables[0].Rows[0]["FeesSubjectName"].ToString();
model.aErpOrderIDStr = ds.Tables[0].Rows[0]["aErpOrderIDStr"].ToString();
if (ds.Tables[0].Rows[0]["APObjType"].ToString() != "")
{
model.APObjType = int.Parse(ds.Tables[0].Rows[0]["APObjType"].ToString());
}
if (ds.Tables[0].Rows[0]["aNPMoney"].ToString() != "")
{
model.aNPMoney = decimal.Parse(ds.Tables[0].Rows[0]["aNPMoney"].ToString());
}
if (ds.Tables[0].Rows[0]["aPMoney"].ToString() != "")
{
model.aPMoney = decimal.Parse(ds.Tables[0].Rows[0]["aPMoney"].ToString());
}
if (ds.Tables[0].Rows[0]["aPayMoney"].ToString() != "")
{
model.aPayMoney = decimal.Parse(ds.Tables[0].Rows[0]["aPayMoney"].ToString());
}
if (ds.Tables[0].Rows[0]["aOtherMoney"].ToString() != "")
{
model.aOtherMoney = decimal.Parse(ds.Tables[0].Rows[0]["aOtherMoney"].ToString());
}
model.aReMake = ds.Tables[0].Rows[0]["aReMake"].ToString();
if (ds.Tables[0].Rows[0]["aDoDateTime"].ToString() != "")
{
model.aDoDateTime = DateTime.Parse(ds.Tables[0].Rows[0]["aDoDateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["aAppendTime"].ToString() != "")
{
model.aAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["aAppendTime"].ToString());
}
if (ds.Tables[0].Rows[0]["FeesSubjectID"].ToString() != "")
{
model.FeesSubjectID = int.Parse(ds.Tables[0].Rows[0]["FeesSubjectID"].ToString());
}
return(model);
}
else
{
return(null);
}
}
