/// <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); } }