public string SetAttr(FormCollection context)
{
UserBll.Instance.CheckUserOnlingState();
var rpm = GetRpm(context);
var u = UserBll.Instance.GetUser(rpm.FID);
if (u != null)
{
if (rpm.Action == "isadmin")
{
var isamdin = rpm.Request("val");
u.IsAdmin = PublicMethod.GetDecimal(isamdin);
}
else if (rpm.Action == "isdisabled")
{
var isdisabled = rpm.Request("val");
u.IsDisabled = PublicMethod.GetDecimal(isdisabled);
}
return(UserBll.Instance.EditUser(u));
}
else
{
return("0");
}
}
public JsonResult Delete(string id)
{
try
{
ICSEOUTBILLDAL.Instance.Delete(id);
var list = ICSEOUTBILLENTRYDAL.Instance.GetWhere(new { FICSEOUTID = id }).ToList();
ICSEOUTBILLENTRYDAL.Instance.DeleteWhere(new { FICSEOUTID = id });
foreach (var model in list)
{
string sql = string.Format("SELECT SUM(FCOMMITQTY*FRATE) FROM V_ICSEOUTBILLENTRY WHERE FICPRID='{0}'", model.FICPRID);
DataTable table = DbUtils.Query(sql);
decimal total = PublicMethod.GetDecimal(table.Rows[0][0]);
ICPRBILLENTRYMODEL icprModel = ICPRBILLENTRYDAL.Instance.Get(model.FICPRID);
if (icprModel != null)
{
icprModel.FLEFTAMOUNT = icprModel.FASKQTY - total;
if (icprModel.FLEFTAMOUNT > 0)
{
icprModel.FSTATUS = 7;
ICPRBILLDAL.Instance.UpdateWhatWhere(new { FSTATUS = (int)Constant.ICPRBILL_FSTATUS.采购确认 }, new { FID = icprModel.FPLANID });
}
ICPRBILLENTRYDAL.Instance.Update(icprModel);
}
}
return(JsonResultHelper.ToSuccess("删除完成！"));
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
return(JsonResultHelper.ToFailed(ex.Message));
}
}
private void onUptTMP_STOCKBill()
{
DataTable table = _service.GetTMP_STOCKBill();
string billno = "";
string billid = "";
foreach (DataRow row in table.Rows)
{
if (billno != row["FBILLNO"].ToString())
{
ICSTOCKBILLMODEL model = new ICSTOCKBILLMODEL();
model.FACCOUNT = PublicMethod.GetString(row["FACCOUNT"]);
model.FBILLNO = PublicMethod.GetString(row["FBILLNO"]);
model.FSYNCSTATUS = PublicMethod.GetInt(row["FSYNCSTATUS"]);
billid = ICSTOCKBILLDAL.Instance.Insert(model);
}
ICSTOCKBILLENTRYMODEL entryModel = new ICSTOCKBILLENTRYMODEL();
entryModel.ICSTOCKBILLID = billid;
entryModel.FENTRYID = PublicMethod.GetDecimal(row["FENTRYID"]);
entryModel.FSRCCODE = PublicMethod.GetString(row["FSRCCODE"]);
entryModel.FSRCMODEL = PublicMethod.GetString(row["FSRCMODEL"]);
entryModel.FBATCHNO = PublicMethod.GetString(row["FBATCHNO"]);
entryModel.FCOLORNO = PublicMethod.GetString(row["FCOLORNO"]);
entryModel.FAUDQTY = PublicMethod.GetDecimal(row["FAUDQTY"]);
entryModel.FBASENUMBER = PublicMethod.GetString(row["FBASENUMBER"]);
entryModel.FSTOCKNUMBER = PublicMethod.GetString(row["FSTOCKNUMBER"]);
entryModel.FSTOCKNAME = PublicMethod.GetString(row["FSTOCKNAME"]);
entryModel.FSPNUMBER = PublicMethod.GetString(row["FSPNUMBER"]);
entryModel.FSPNAME = PublicMethod.GetString(row["FSPNAMEFACCOUNT"]);
entryModel.FREMARK = PublicMethod.GetString(row["FREMARKFACCOUNT"]);
ICSTOCKBILLENTRYDAL.Instance.Insert(entryModel);
billno = row["FBILLNO"].ToString();
}
}
public string Save(ICSEOUTBILLMODEL ICSEOUTBILL, IEnumerable <ICSEOUTBILLENTRYMODEL> ICSEOUTBILLENTRYList)
{
#region 检查
ICSEOUTBILLMODEL temp = ICSEOUTBILLDAL.Instance.GetWhere(new { FBILLNO = ICSEOUTBILL.FBILLNO }).FirstOrDefault();
if (temp != null && temp.FID != ICSEOUTBILL.FID)
{
return("单据单号重复！");
}
//foreach (var item in ICSEOUTBILLENTRYList.GroupBy(i => i.FITEMID + i.FENTRYID))
//{
// if (item.Count() > 1)
// {
// return "商品资料重复！";
// }
//}
#endregion
string FID = ICSEOUTBILL.FID;
ICSEOUTBILL.FSTATUS = Constant.BILL_FSTATUS.草稿.ToInt();
if (FID.IsNullOrEmpty())
{
if (ICSEOUTBILL.FBILLERID == null)
{
ICSEOUTBILL.FBILLERID = SysVisitor.Instance.UserId;
}
ICSEOUTBILL.FBILLDATE = DateTime.Now;
ICSEOUTBILL.FCAR_STATUS = 1; // 1:待发布，2:已发布，3:发布失败，4:已确认，5:关闭，6:关闭（改）
FID = ICSEOUTBILLDAL.Instance.Insert(ICSEOUTBILL);
if (!FID.IsGuid())
{
return("发货通知保存失败！");
}
}
else
{
int status = ICSEOUTBILLDAL.Instance.GetStatus(ICSEOUTBILL.FID);
if (status == Constant.BILL_FSTATUS.审核通过.ToInt())
{
return("该发货通知已经审核，不允许编辑！");
}
if (status == Constant.BILL_FSTATUS.完成.ToInt())
{
return("该发货通知已经完成，不允许编辑！");
}
if (status == Constant.BILL_FSTATUS.关闭.ToInt())
{
return("该发货通知已经关闭，不允许编辑！");
}
//int result = ICSEOUTBILLDAL.Instance.Update(ICSEOUTBILL);
int result = ICSEOUTBILLDAL.Instance.UpdateWhatWhere(new
{
FPREMISEID = ICSEOUTBILL.FPREMISEID,
FBRANDID = ICSEOUTBILL.FBRANDID,
FCLIENTID = ICSEOUTBILL.FCLIENTID,
FBILLNO = ICSEOUTBILL.FBILLNO,
FSTATUS = Constant.BILL_FSTATUS.草稿.ToInt(),
FCARNUMBER = ICSEOUTBILL.FCARNUMBER,
FLOADCAPACITY = ICSEOUTBILL.FLOADCAPACITY,
FDELIVERER = ICSEOUTBILL.FDELIVERER,
FDELIVERERTEL = ICSEOUTBILL.FDELIVERERTEL,
FDELIVERERIDNO = ICSEOUTBILL.FDELIVERERIDNO,
FDELIVERERADDR = ICSEOUTBILL.FDELIVERERADDR,
FRECEIVER = ICSEOUTBILL.FRECEIVER,
FRECEIVERTEL = ICSEOUTBILL.FRECEIVERTEL,
FRECEIVERADDR = ICSEOUTBILL.FRECEIVERADDR,
FALLWEIGHT = ICSEOUTBILL.FALLWEIGHT,
FALLVOLUME = ICSEOUTBILL.FALLVOLUME,
FREMARK = ICSEOUTBILL.FREMARK,
FTRANSTYPE = ICSEOUTBILL.FTRANSTYPE,
FTRANSID = ICSEOUTBILL.FTRANSID,
FDELIVERDATE = ICSEOUTBILL.FDELIVERDATE,
FEXPRESSCOMPANYID = ICSEOUTBILL.FEXPRESSCOMPANYID,
FPROJECTNAME = ICSEOUTBILL.FPROJECTNAME,
FCENTER_WAREHOUSE = ICSEOUTBILL.FCENTER_WAREHOUSE,
FDELIVERY_METHOD = ICSEOUTBILL.FDELIVERY_METHOD,
FPURCHASE_NO = ICSEOUTBILL.FPURCHASE_NO,
FPLANDESC = ICSEOUTBILL.FPLANDESC,
FIS_CONSIGN = ICSEOUTBILL.FIS_CONSIGN,
FBILLING_TYPE = ICSEOUTBILL.FBILLING_TYPE,
FSETTLE_ORG = ICSEOUTBILL.FSETTLE_ORG,
FDELIVERY_REQUIRE = ICSEOUTBILL.FDELIVERY_REQUIRE,
FBRAND_DEPART = ICSEOUTBILL.FBRAND_DEPART,
}, new
{
FID = ICSEOUTBILL.FID
});
if (result <= 0)
{
return("发货通知保存失败！");
}
}
var entrys = ICSEOUTBILLENTRYDAL.Instance.GetWhere(new { FICSEOUTID = FID }).ToList();
//删除明细
ICSEOUTBILLENTRYBLL.Instance.DeleteByICSEOUTBILLID(FID);
foreach (var model in entrys)
{
var count = ICSEOUTBILLENTRYList.Where(m => m.FICPRID == model.FICPRID).Count();
if (count == 0)
{
string sql = string.Format("SELECT SUM(FCOMMITQTY*FRATE) FROM V_ICSEOUTBILLENTRY WHERE FICPRID='{0}' and (FGROUP_STATUS is null or FGROUP_STATUS = 0)", model.FICPRID);
DataTable table = DbUtils.Query(sql);
decimal total = PublicMethod.GetDecimal(table.Rows[0][0]);
ICPRBILLENTRYMODEL icprModel = ICPRBILLENTRYDAL.Instance.Get(model.FICPRID);
if (icprModel != null)
{
icprModel.FLEFTAMOUNT = icprModel.FASKQTY - total;
if (icprModel.FLEFTAMOUNT <= 0)
{
icprModel.FSTATUS = 5;
}
else
{
icprModel.FSTATUS = 7;
}
ICPRBILLENTRYDAL.Instance.Update(icprModel);
if (ICPRBILLENTRYDAL.Instance.GetCloseStatus(icprModel.FPLANID) == 0)
{
ICPRBILLDAL.Instance.UpdateWhatWhere(new { FSTATUS = (int)Constant.ICPRBILL_FSTATUS.关闭 }, new { FID = icprModel.FPLANID });
}
else
{
ICPRBILLDAL.Instance.UpdateWhatWhere(new { FSTATUS = (int)Constant.ICPRBILL_FSTATUS.采购确认 }, new { FID = icprModel.FPLANID });
}
}
}
}
foreach (var item in ICSEOUTBILLENTRYList)
{
item.FICSEOUTID = FID;
string id = ICSEOUTBILLENTRYDAL.Instance.Insert(item);
LogHelper.WriteLog("herherehrer:" + item.thdbm);
//var list = ICSEOUTBILLENTRYDAL.Instance.GetWhere(new { FICPRID = item.FICPRID });
string sql = string.Format("SELECT SUM(FCOMMITQTY*FRATE) FROM V_ICSEOUTBILLENTRY WHERE FICPRID='{0}' and (FGROUP_STATUS is null or FGROUP_STATUS = 0)", item.FICPRID);
DataTable table = DbUtils.Query(sql);
decimal total = PublicMethod.GetDecimal(table.Rows[0][0]);
ICPRBILLENTRYMODEL icprModel = ICPRBILLENTRYDAL.Instance.Get(item.FICPRID);
if (icprModel != null)
{
icprModel.FLEFTAMOUNT = icprModel.FASKQTY - total;
if (icprModel.FLEFTAMOUNT <= 0)
{
icprModel.FSTATUS = 5;
}
else
{
icprModel.FSTATUS = 7;
}
ICPRBILLENTRYDAL.Instance.Update(icprModel);
if (ICPRBILLENTRYDAL.Instance.GetCloseStatus(icprModel.FPLANID) == 0)
{
ICPRBILLDAL.Instance.UpdateWhatWhere(new { FSTATUS = (int)Constant.ICPRBILL_FSTATUS.关闭 }, new { FID = icprModel.FPLANID });
}
else
{
ICPRBILLDAL.Instance.UpdateWhatWhere(new { FSTATUS = (int)Constant.ICPRBILL_FSTATUS.采购确认 }, new { FID = icprModel.FPLANID });
}
}
//ICPRBILLENTRYMODEL icprModel = ICPRBILLENTRYDAL.Instance.Get(item.FICPRID);
//if (icprModel != null)
//{
// if (icprModel.FORDERUNITQTY >= total)
// {
// icprModel.FLEFTAMOUNT = icprModel.FLEFTAMOUNT - total;
// }
// else
// {
// icprModel.FLEFTAMOUNT = 0;
// }
// ICPRBILLENTRYDAL.Instance.Update(icprModel);
//}
}
return(null);
}
