/// <summary>
/// 新增
/// </summary>
/// <param name="FittingsInfo"></param>
/// <returns></returns>
public ActionResult InsertSpare(SYS_FittingsInfo FittingsInfo)
{
string strMsg = "fail";
try
{
//判断配件信息表是否存在新增的配件信息
var SelectCount = (from tbFittingsInfo in myModels.SYS_FittingsInfo
where tbFittingsInfo.FittingsInfoID == FittingsInfo.FittingsInfoID ||
tbFittingsInfo.FittingsName == FittingsInfo.FittingsName
select tbFittingsInfo).Count();
if (SelectCount == 0)
{
myModels.SYS_FittingsInfo.Add(FittingsInfo);
myModels.SaveChanges();
strMsg = "success";
}
else
{
strMsg = "该配件信息已存在，不需要重复输入数据！";
}
}
catch (Exception e)
{
strMsg = "failed";
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
public ActionResult InsertFittingsInfo(SYS_FittingsInfo sys_FittingsInfo, HttpPostedFileBase fileCarPicture)//新增配件信息
{
try
{
byte[] imgFile = null;
if (fileCarPicture != null && fileCarPicture.ContentLength > 0)
{ //读取该图片文件
//将图片转为流结束位置
//将流读取为byte[]，参数：byte[]，读取开始位置，读取字节数
imgFile = new byte[fileCarPicture.ContentLength];//初始化图片的长度
fileCarPicture.InputStream.Read(imgFile, 0, fileCarPicture.ContentLength);
sys_FittingsInfo.Picture = imgFile;
}
myModels.SYS_FittingsInfo.Add(sys_FittingsInfo);
myModels.SaveChanges();
}
catch (Exception)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateSpare(SYS_FittingsInfo FittingsInfo)
{
var strMsg = "failed";
try
{
//判断修改后的数据是否与数据库重复
var oldFittingsInfoRow = (from tbFittingsInfo in myModels.SYS_FittingsInfo
where tbFittingsInfo.FittingsInfoID == FittingsInfo.FittingsInfoID &&
(tbFittingsInfo.FittingsName == FittingsInfo.FittingsName ||
tbFittingsInfo.FittingsCode == FittingsInfo.FittingsCode)
select tbFittingsInfo).Count();
if (oldFittingsInfoRow == 0)
{
myModels.Entry(FittingsInfo).State = System.Data.Entity.EntityState.Modified;
//保存数据库
myModels.SaveChanges();
strMsg = "success";
//myModels.Entry(FittingsInfo).State = System.Data.Entity.EntityState.Modified;
////保存数据库
//if (myModels.SaveChanges() > 0)
//{
// strMsg = "success";
//}
}
else
{
strMsg = "配件名称已存在！";
}
}
catch (Exception)
{
strMsg = "修改失败";
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
