public ActionResult NewAccount(yhxx yhxx)
{
baseDAL.AddItem <yhxx>(yhxx);
baseDAL.SaveAllChanges();
var yhxxList = baseDAL.Get <yhxx>().ToList();
return(Json(yhxxList));
}
public string chongzhi(SellInfo sellInfo)
{
yhxx yhxx = baseDAL.Get <yhxx>().FirstOrDefault(c => c.ywbh == sellInfo.ywbh);
yhxx.gqcs += 1;
if (yhxx.gqzl == null)
{
yhxx.gqzl = sellInfo.gql;
}
else
{
yhxx.gqzl += sellInfo.gql;
}
yhxx.gqrq = DateTime.Now;
//向营业数据表插入信息
yysj newYysj = new yysj();
newYysj.ywbh = sellInfo.ywbh;
newYysj.skcs = baseDAL.Get <yysj>().Where(c => c.ywbh == sellInfo.ywbh).Count() + 1;
newYysj.skrq = (DateTime)yhxx.gqrq;
newYysj.skje = (decimal)sellInfo.qjMoney;
newYysj.skql = sellInfo.gql;
newYysj.czy = (string)Session["user_id"];
newYysj.bb = 1;
newYysj.hh = 1;
newYysj.sjkb = 1;
newYysj.time = DateTime.Now;
newYysj.gzzbh = 1;
newYysj.lstbz = 1;
newYysj.bqbz = 0;
newYysj.zfbz = 0;
string fpbh = "IC0010701 ";
fpbh += baseDAL.Get <yysj>().Count().ToString();
newYysj.fpbh = fpbh;
baseDAL.AddItem <yysj>(newYysj);
//放入session以备打印
Session["ywbhP"] = sellInfo.ywbh;
Session["fpbhP"] = fpbh;
Session["gqlP"] = sellInfo.gql;
Session["qjMoneyP"] = sellInfo.qjMoney;
Session["moneyTotalP"] = sellInfo.moneyTotal;
Session["returnMoneyP"] = sellInfo.returnMoney;
if (baseDAL.SaveAllChanges())
{
return("充值成功！");
}
else
{
return("充值失败！");
}
}
public JsonResult UpdateNewUser(yhxx newYhxx)
{
int ywbhNum;
int total = baseDAL.Get <bhIndex>().Count();
if (total == 0)
{
ywbhNum = 1;
}
else
{
ywbhNum = total + 1;
}
var bhIndex = new bhIndex
{
ywbh = ywbhNum
};
baseDAL.AddItem <bhIndex>(bhIndex);
int yhlxNum = (int)newYhxx.yhlx;
djgl djgl = baseDAL.Get <djgl>().FirstOrDefault(c => c.yhlx == yhlxNum);
if (newYhxx.hm != null)
{
var newUser = baseDAL.Get <yhxx>().FirstOrDefault(c => c.kpbh == newYhxx.kpbh);
newUser.ywbh = ywbhNum;
newUser.fkrq = DateTime.Now;
newUser.gqcs = 0;
Session["ywbh"] = newUser.ywbh;
Session["hm"] = newUser.hm;
Session["zz"] = newUser.zz;
Session["yhlx"] = newUser.yhlx;
Session["tel"] = newUser.tel;
Session["yhlxms"] = djgl.ms;
Session["qj"] = djgl.qj;
Session["gqcs"] = newUser.gqcs + 1;
baseDAL.SaveAllChanges();
}
else
{
Session["ywbh"] = ywbhNum;
Session["hm"] = null;
Session["zz"] = null;
Session["yhlx"] = newYhxx.yhlx;
Session["tel"] = null;
Session["yhlxms"] = djgl.ms;
Session["gqcs"] = 0;
baseDAL.SaveAllChanges();
}
return(Json(ywbhNum));
}
public String getUserByYwbh(yhxx postYhxx)
{
var yhxx = baseDAL.Get <yhxx>().FirstOrDefault(c => c.ywbh == postYhxx.ywbh);
Session["ywbh"] = yhxx.ywbh;
Session["hm"] = yhxx.hm;
Session["zz"] = yhxx.zz;
Session["yhlx"] = yhxx.yhlx;
Session["tel"] = yhxx.tel;
Session["gqcs"] = yhxx.gqcs;
return("../SellCard/NewCardCharge");
}
public ActionResult UpdateNewUser(yhxx newYhxx)
{
int ywbhNum;
int total = baseDAL.Get <bhIndex>().ToList().Count;
if (total == 0)
{
ywbhNum = 1;
}
else
{
ywbhNum = total + 1;
}
var bhIndex = new bhIndex
{
ywbh = ywbhNum,
};
baseDAL.AddItem <bhIndex>(bhIndex);
if (newYhxx.hm != null)
{
var newUser = baseDAL.Get <yhxx>().FirstOrDefault(c => c.kpbh == newYhxx.kpbh);
newUser.hm = newYhxx.hm;
newUser.tel = newYhxx.tel;
newUser.ywbh = ywbhNum;
newUser.gqcs = 1;
Session["ywbh"] = newUser.ywbh;
Session["hm"] = newUser.hm;
Session["zz"] = newUser.zz;
Session["yhlx"] = newUser.yhlx;
Session["tel"] = newUser.tel;
Session["gqcs"] = newUser.gqcs;
baseDAL.SaveAllChanges();
}
else
{
Session["ywbh"] = ywbhNum;
Session["hm"] = null;
Session["zz"] = null;
Session["yhlx"] = newYhxx.yhlx;
Session["tel"] = null;
Session["gqcs"] = 0;
}
return(Json(ywbhNum));
}
public JsonResult Update(yhxx newYhxx)
{
var newUser = baseDAL.Get <yhxx>().FirstOrDefault(c => c.kpbh == newYhxx.kpbh);
newUser.hm = newYhxx.hm;
newUser.tel = newYhxx.tel;
newUser.bz = newYhxx.bz;
if (baseDAL.SaveAllChanges())
{
return(Json(newUser));
}
else
{
return(Json("修改用户资料失败！"));
}
}
public string UserInfoQuery(ChooseQuery choosequery)
{
// Session["choosequery"] = choosequery;
yhxx yhxx = null;
string str1 = choosequery.ChooseContent;
string str2 = choosequery.QueryContent;
if (str1.Equals("ywbh"))
{
int ywbhNum = int.Parse(str2);
yhxx = baseDAL.Get <yhxx>().FirstOrDefault(c => c.ywbh == ywbhNum);
}
else if (str1.Equals("kpbh"))
{
int kpbhNum = int.Parse(str2);
yhxx = baseDAL.Get <yhxx>().FirstOrDefault(c => c.kpbh == kpbhNum);
}
else if (str1.Equals("hm"))
{
yhxx = baseDAL.Get <yhxx>().FirstOrDefault(c => c.hm.Equals(str2));
}
else if (str1.Equals("zz"))
{
yhxx = baseDAL.Get <yhxx>().FirstOrDefault(c => c.zz.Equals(str2));
}
else
{
yhxx = baseDAL.Get <yhxx>().FirstOrDefault(c => c.tel.Equals(str2));
}
// var djglList = baseDAL.Get<djgl>().ToList();
// ViewBag.djglList = djglList;
// var Yhxxlist = Json(yhxxlist);
// ViewBag.yhxxlist = Yhxxlist;
if (yhxx != null)
{
var djgl = baseDAL.Get <djgl>().FirstOrDefault(c => c.yhlx == yhxx.yhlx);
Session["yhlx"] = djgl.ms;
Session["yhxx"] = yhxx;
return("../QueryStatistics/UserInfoQuery_Back");
}
else
{
return("用户不存在！");
}
}
public string PrintData()
{
if (Session["ywbhP"] != null)
{
int ywbh = (int)Session["ywbhP"];
yhxx yHxx = baseDAL.Get <yhxx>().FirstOrDefault(c => c.ywbh == ywbh);
DateTime dt = (DateTime)yHxx.gqrq;
Session["gqrqP"] = dt.ToString("yyy-MM-dd");
Session["hmP"] = yHxx.hm;
Session["zzP"] = yHxx.zz;
djgl dJgl = baseDAL.Get <djgl>().FirstOrDefault(c => c.yhlx == yHxx.yhlx);
Session["qjP"] = dJgl.qj;
return("../ReportPrint/Print");
}
else
{
return("");
}
}
public ActionResult chongzhi(yhxx Yhxx)
{
DateTime now = DateTime.Now;
now.GetDateTimeFormats();
var yhxx = baseDAL.Get <yhxx>().FirstOrDefault(c => c.ywbh == Yhxx.ywbh);
if (yhxx.gqzl == null)
{
yhxx.gqzl = Yhxx.gqzl;
}
else
{
yhxx.gqcs = yhxx.gqcs + 1;
yhxx.gqzl = Yhxx.gqzl + yhxx.gqzl;
}
yhxx.gqrq = now;
baseDAL.SaveAllChanges();
return(Json(yhxx));
}
public ActionResult UserInfoQuery_Back()
{
yhxx yhxx = (yhxx)Session["yhxx"];
List <yhxx> yhxxlist = new List <yhxx>();
yhxxlist.Add(yhxx);
ViewBag.yhxxlist = yhxxlist;
ViewBag.ywbh = yhxx.ywbh;
ViewBag.hm = yhxx.hm;
ViewBag.tel = yhxx.tel;
ViewBag.kpbh = yhxx.kpbh;
ViewBag.zz = yhxx.zz;
ViewBag.gqcs = yhxx.gqcs;
ViewBag.gqzl = yhxx.gqzl;
ViewBag.yhlx = Session["yhlx"];
DateTime dt = (DateTime)yhxx.gqrq;
ViewBag.gqrq = dt.ToString("yyyy-MM-dd");
ViewBag.zxh = yhxx.zxh;
return(View());
}
public String getUserByYwbh(yhxx postYhxx)
{
yhxx Yhxx = null;
Yhxx = baseDAL.Get <yhxx>().FirstOrDefault(c => c.ywbh == postYhxx.ywbh);
if (Yhxx != null)
{
djgl djgl = baseDAL.Get <djgl>().FirstOrDefault(c => c.yhlx == Yhxx.yhlx);
Session["ywbh"] = Yhxx.ywbh;
Session["hm"] = Yhxx.hm;
Session["zz"] = Yhxx.zz;
Session["yhlxms"] = djgl.ms;
Session["tel"] = Yhxx.tel;
Session["gqcs"] = Yhxx.gqcs;
Session["qj"] = djgl.qj;
return("../SellCard/NewCardCharge");
}
else
{
return("../FaKaRecharge/fakaRecharge");
}
}
public string ChangeMeter(yhxx Yhxx)
{
Session["ywbh"] = Yhxx.ywbh;
Session["hm"] = Yhxx.hm;
return("../QueryStatistics/ChangeMeter_Back");
}
public string FillInfoDetail(yhxx Yhxx)
{
Session["ywbh"] = Yhxx.ywbh;
Session["hm"] = Yhxx.hm;
return("../QueryStatistics/FillInfoDetail_Back");
}
