/// <summary>
/// 添加养护附件
/// </summary>
/// <param name="model"></param>
public void AddFile(YH_FileModel model)
{
using (Entities db = new Entities())
{
yh_files yhmodel = new yh_files();
//yhmodel.fileid = model.fileid;
yhmodel.filesource = model.filesource;
yhmodel.sourceid = model.sourceid;
yhmodel.filename = model.filename;
yhmodel.filetype = model.filetype;
yhmodel.filepath = model.filepath;
yhmodel.filesize = model.filesize;
db.yh_files.Add(yhmodel);
db.SaveChanges();
}
}
public int DeleteContractInf(int contractid)
{
using (Entities db = new Entities())
{
yh_contracts model = db.yh_contracts.SingleOrDefault(t => t.contractid == contractid);
if (model != null)
{
db.yh_contracts.Remove(model);
}
//删除附件
do
{
yh_files file_model = db.yh_files.FirstOrDefault(a => a.sourceid == contractid && a.filesource == 1);
if (file_model != null)
{
db.yh_files.Remove(file_model);
}
}while (db.SaveChanges() > 0);
return(db.SaveChanges());
}
}
public int ModifyContractInf(YH_ContractModel model, List <FileUploadClass> list)
{
bool info = false, file = false;
using (Entities db = new Entities())
{
yh_contracts bags_model = db.yh_contracts.FirstOrDefault(a => a.contractid == model.contractid);
if (bags_model != null)
{
bags_model.contractname = model.contractname;
bags_model.patrolexplain = model.patrolexplain;
bags_model.contractnum = model.contractnum;
bags_model.jfdw = model.jfdw;
bags_model.jfdb = model.jfdb;
bags_model.yfdw = model.yfdw;
bags_model.yfdb = model.yfdb;
bags_model.jldw = model.jldw;
bags_model.starttime = model.starttime;
bags_model.endtime = model.endtime;
bags_model.signdate = model.signdate;
bags_model.summoney = model.summoney;
bags_model.htzxzt = model.htzxzt;
bags_model.currentmoney = model.currentmoney;
bags_model.contactendtime = model.contactendtime;
bags_model.contacttype = model.contacttype;
bags_model.contracttype = model.contracttype;
bags_model.yhmoney = model.yhmoney;
bags_model.patrolemoney = model.patrolemoney;
if (db.SaveChanges() > 0)
{
info = true;
}
}
foreach (var item in list)
{
yh_files filemodel = new yh_files();
filemodel.filesource = 1; //1合同2日志3单位
filemodel.filename = item.OriginalName;
filemodel.filepath = item.OriginalPath;
filemodel.filesize = item.size;
filemodel.filetype = item.OriginalType;
filemodel.sourceid = bags_model.contractid;
db.yh_files.Add(filemodel);
}
if (db.SaveChanges() > 0)
{
file = true;
}
if (info && file)
{
return(1);
}
else
{
return(0);
}
}
}
/// <summary>
/// 添加养护合同
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddContract(YH_ContractModel model, List <FileClass> list)
{
bool info = false, file = false;
using (Entities db = new Entities())
{
yh_contracts yhmodel = new yh_contracts();
yhmodel.contractid = model.contractid;
yhmodel.contractname = model.contractname;
yhmodel.patrolexplain = model.patrolexplain;
yhmodel.contractnum = model.contractnum;
yhmodel.jfdw = model.jfdw;
yhmodel.jfdb = model.jfdb;
yhmodel.yfdw = model.yfdw;
yhmodel.yfdb = model.yfdb;
yhmodel.jldw = model.jldw;
yhmodel.starttime = model.starttime;
yhmodel.endtime = model.endtime;
yhmodel.signdate = model.signdate;
yhmodel.summoney = model.summoney;
yhmodel.htzxzt = model.htzxzt;
yhmodel.currentmoney = model.currentmoney;
yhmodel.contactendtime = model.contactendtime;
yhmodel.contacttype = model.contacttype;
yhmodel.contracttype = model.contracttype;
yhmodel.yhmoney = model.yhmoney;
yhmodel.patrolemoney = model.patrolemoney;
yhmodel.createuserid = model.createuserid;
yhmodel.createtime = DateTime.Now;
db.yh_contracts.Add(yhmodel);
if (db.SaveChanges() > 0)
{
info = true;
}
foreach (var item in list)
{
yh_files filemodel = new yh_files();
filemodel.filesource = 1; //1合同 2日志 3单位
filemodel.filename = item.OriginalName;
filemodel.filepath = item.OriginalPath;
filemodel.filesize = item.size;
filemodel.filetype = item.OriginalType;
filemodel.sourceid = yhmodel.contractid;
db.yh_files.Add(filemodel);
}
if (db.SaveChanges() > 0)
{
file = true;
}
if (info || (info && file))
{
return(1);
}
else
{
return(0);
}
}
}
