public IHttpActionResult BasicEidt(PBE_LIST infos)
{
using (ZDSYYC db = new ZDSYYC())
{
//项目
var sql = "update pbe_std set PIGLETQTY= " + infos.PBE_PROJECTINFO.PIGLETQTY + ",ADJUSTFEE=" + infos.PBE_PROJECTINFO.ADJUSTFEE + ",CULLINGRATE=" + infos.PBE_PROJECTINFO.CULLINGRATE + ",PERFECTRATE=" + infos.PBE_PROJECTINFO.PERFECTRATE + ",NOPERFRATE=" + infos.PBE_PROJECTINFO.NOPERFRATE + ",NOPERFWGTRATE=" + infos.PBE_PROJECTINFO.NOPERFWGTRATE + " where project='001'";
int allnum = db.ExecuteNoQuery(sql);
var sql1 = "update PBE_PIGLETCOST set management = " + infos.PBE_PIGLETCOSTINFO.MANAGEMENT + ", farm =" + infos.PBE_PIGLETCOSTINFO.FARM + " where project = '001'";
int allnum1 = db.ExecuteNoQuery(sql1);
var sql2 = "update PBE_PIGMARKETPRICE set CONTRACT = " + infos.PBE_PIGMARKETPRICEINFO.CONTRACT + ", MARKET =" + infos.PBE_PIGMARKETPRICEINFO.MARKET + " where project = '001'";
int allnum2 = db.ExecuteNoQuery(sql2);
var sql3 = "update PBE_MEDICINECOST set MANAGEMENT = " + infos.PBE_MEDICINECOSTINFO.MANAGEMENT + ", FARM =" + infos.PBE_MEDICINECOSTINFO.FARM + " where project = '001'";
int allnum3 = db.ExecuteNoQuery(sql3);
db.Save();
return(Succeed(""));
}
}
public IHttpActionResult UserDisable(PBE_USER info)
{
using (ZDSYYC db = new ZDSYYC())
{
var sql = "update PBE_USER set password='******' where code='jy00001'";
int allnum = db.ExecuteNoQuery(sql);
db.Save();
return(Succeed("禁用成功"));
}
}
public IHttpActionResult FeedEidt(PBE_LIST infos)
{
using (ZDSYYC db = new ZDSYYC())
{
foreach (var item in infos.PBE_FEEDCOSTList)
{
var sql = "update PBE_FEED set feedfac=" + item.FEEDFAC + " ,management=" + item.MANAGEMENT + ", faRm=" + item.FARM + " where code ='" + item.FEED + "'";
int allnum = db.ExecuteNoQuery(sql);
}
db.Save();
return(Succeed(db.PBE_FEED.AsQuery().ToList()));
}
}
public IHttpActionResult VacEidt(PBE_LIST infos)
{
using (ZDSYYC db = new ZDSYYC())
{
foreach (var item in infos.PBE_VACCINECOSTList)
{
var sql = "update pbe_Vaccine set management=" + item.MANAGEMENT + ", faRm=" + item.FARM + " where code ='" + item.CODE + "'";
int allnum = db.ExecuteNoQuery(sql);
}
db.Save();
return(Succeed(db.PBE_VACCINE.AsQuery().ToList()));
}
}
public IHttpActionResult EditShowProfit(PBE_PROJECT info)
{
using (ZDSYYC db = new ZDSYYC())
{
var sql = "update PBE_PROJECT set CULLINGRATE= " + info.CULLINGRATE + ", PERFECTRATE=" + info.PERFECTRATE + ", NOPERFRATE=" + (100 - info.PERFECTRATE) + " where PROJECT='" + info.PROJECT + "'";
var sql1 = "update PBE_PIGMARKETPRICE set market=" + info.NOPERFRATE + " where PROJECT='" + info.PROJECT + "'";
int allnum = db.ExecuteNoQuery(sql);
int allnum1 = db.ExecuteNoQuery(sql1);
db.Save();
var q = db.PBE_PROJECT.AsQuery().Where(w => w.PROJECT == info.PROJECT).ToList()[0];
var qq = db.PBE_PIGMARKETPRICE.AsQuery().Where(w => w.PROJECT == info.PROJECT).ToList()[0];
var query = db.PBE_V_BUDGET.AsQuery().Where(w => w.PROJECT == info.PROJECT).ToList()[0];
var feedCost = query.Feedfac;
var feedIncome = query.Feedmanagement;
var feedProfit = feedIncome - feedCost;
var manCost = query.Feedmanagement + query.Medmanagement + query.VacMANAGEMENT + query.PigletMANA + query.Contract + query.ADJUSTFEE;
var manIncome = query.Feedfarm + query.Medfarm + query.VacFARM + query.PigletFARM + query.Market;
var manProfit = manIncome - manCost;
var farmCost = query.Feedfarm + query.Medfarm + query.VacFARM + query.PigletFARM;
var farmIncome = query.Contract + query.ADJUSTFEE;
var farmProfit = farmIncome - farmCost;
var result = new string[9, 2] {
{ "feedCost", feedCost.ToString("0.00") }, { "feedIncome", feedIncome.ToString("0.00") }, { "feedProfit", feedProfit.ToString("0.00") }, { "manCost", manCost.ToString("0.00") }, { "manIncome", manIncome.ToString("0.00") }, { "manProfit", manProfit.ToString("0.00") }, { "farmCost", farmCost.ToString("0.00") }, { "farmIncome", farmIncome.ToString("0.00") }, { "farmProfit", farmProfit.ToString("0.00") }
};
var s = new
{
plist = q,
pm = qq,
slist = result
};
return(Succeed(s));
}
}
public IHttpActionResult UserEditPwdYC(PBE_USER info)
{
using (ZDSYYC db = new ZDSYYC())
{
string code = info.CODE;
string oldpwd = info.NAME;
string _password = info.PASSWORD;
var sqlNum = "update PBE_USER set password='******' where code='" + code + "' and password='******'";
int allnum = db.ExecuteNoQuery(sqlNum);
db.Save();
if (allnum == 1)
{
return(Succeed("修改成功", 0, ""));
}
else
{
return(Succeed("修改失败", 1, "", "旧密码错误"));
}
}
}
