public IHttpActionResult EditProject(PBE_LIST info)
{
using (ZDSYYC db = new ZDSYYC())
{
string projectID = "";
if (info.Skin != "0") //如果是编辑状态，删除在添加
{
projectID = info.Skin;
db.PBE_PROJECT.Remove(w => w.PROJECT == projectID);
db.PBE_FEEDCOST.Remove(w => w.PROJECT == projectID);
db.PBE_VACCINECOST.Remove(w => w.PROJECT == projectID);
db.PBE_PIGLETCOST.Remove(w => w.PROJECT == projectID);
db.PBE_PIGMARKETPRICE.Remove(w => w.PROJECT == projectID);
db.PBE_MEDICINECOST.Remove(w => w.PROJECT == projectID);
}
if (projectID == "")
{
var sql = "select max(project)from PBE_PROJECT where user1 = '" + info.User + "'";
string num = db.ExecuteScalar(sql).ToString();
if (num == "")
{
projectID = info.User + "0001";
}
else
{
int nnn = int.Parse(num.Substring(num.Length - 4)) + 1;
projectID = info.User + string.Format("{0:0000}", nnn);
}
}
//饲料
int id = 0;
foreach (var item in info.PBE_FEEDCOSTList)
{
id++;
PBE_FEEDCOST infos = new PBE_FEEDCOST();
infos.PROJECT = projectID;
infos.ID = id;
infos.FEED = item.FEED;
infos.FEEDFAC = item.FEEDFAC;
infos.MANAGEMENT = item.MANAGEMENT;
infos.FARM = item.FARM;
db.PBE_FEEDCOST.Add(infos);
}
//疫苗
id = 0;
foreach (var item in info.PBE_VACCINECOSTList)
{
id++;
PBE_VACCINECOST infos = new PBE_VACCINECOST();
infos.PROJECT = projectID;
infos.ID = id;
infos.CODE = item.CODE;
infos.NAME = item.NAME;
infos.MANAGEMENT = item.MANAGEMENT;
infos.FARM = item.FARM;
db.PBE_VACCINECOST.Add(infos);
}
//项目
var query3 = db.PBE_STD.AsQuery().ToList().Where(w => w.PROJECT == "001").ToList(); //日龄相关标准
PBE_PROJECT pebinfo = new PBE_PROJECT();
pebinfo.INDATE = query3[0].INDATE;
pebinfo.INDAY = query3[0].INDAY;
pebinfo.OUTDAY = query3[0].OUTDAY;
pebinfo.OUTWGT = query3[0].OUTWGT;
pebinfo.NOPERFWGTRATE = query3[0].NOPERFWGTRATE;
pebinfo.NOPERFPRICERATE = query3[0].NOPERFPRICERATE;
pebinfo.NOPERFRATE = 100 - info.PBE_PROJECTINFO.PERFECTRATE;
pebinfo.USER1 = info.User;
pebinfo.PROJECT = projectID; // 进猪数量 代养费 死淘 一级
pebinfo.PIGLETQTY = info.PBE_PROJECTINFO.PIGLETQTY;
pebinfo.ADJUSTFEE = info.PBE_PROJECTINFO.ADJUSTFEE;
pebinfo.CULLINGRATE = info.PBE_PROJECTINFO.CULLINGRATE;
pebinfo.PERFECTRATE = info.PBE_PROJECTINFO.PERFECTRATE;
pebinfo.INDATE = DateTime.Now;
db.PBE_PROJECT.Add(pebinfo);
//小猪
PBE_PIGLETCOST pebpig = new PBE_PIGLETCOST();
pebpig.PROJECT = projectID;
pebpig.MANAGEMENT = info.PBE_PIGLETCOSTINFO.MANAGEMENT;
pebpig.FARM = info.PBE_PIGLETCOSTINFO.FARM;
db.PBE_PIGLETCOST.Add(pebpig);
//成品猪
PBE_PIGMARKETPRICE pebpigm = new PBE_PIGMARKETPRICE();
pebpigm.PROJECT = projectID;
pebpigm.MARKET = info.PBE_PIGMARKETPRICEINFO.MARKET;
pebpigm.CONTRACT = info.PBE_PIGMARKETPRICEINFO.CONTRACT;
db.PBE_PIGMARKETPRICE.Add(pebpigm);
//药品
PBE_MEDICINECOST pebmed = new PBE_MEDICINECOST();
pebmed.PROJECT = projectID;
pebmed.MANAGEMENT = info.PBE_MEDICINECOSTINFO.MANAGEMENT;
pebmed.FARM = info.PBE_MEDICINECOSTINFO.FARM;
db.PBE_MEDICINECOST.Add(pebmed);
db.Save();
return(Succeed(projectID));
}
}
