/// <summary>
/// 模型数据改变
/// </summary>
/// <param name="obj"></param>
private void dataChanged(MaterialInfoModel MaterialInfoChange)
{
getPageData(pageRepuestParams.PageIndex, pageRepuestParams.PageSize);
var tmpModel = MaterialInfoList.FirstOrDefault(a => a.Id == MaterialInfoChange.Id);
this.MaterialInfo = MaterialInfoList.FirstOrDefault();
}
private MaterialInfoModel EntityToModel(DataRow dr)
{
if (dr != null)
{
MaterialInfoModel model = new MaterialInfoModel();
model.MediaID = dr["media_id"].ToString();
model.Name = dr["name"] == null ? null : dr["name"].ToString();
model.Url = dr["url"] == null ? null : dr["url"].ToString();
model.CreateTime = dr["create_time"].ToDateTime();
model.UpdateTime = dr["update_time"].ToDateTime();
return(model);
}
return(null);
}
/// <summary>
/// 物料选择项改变命令函数
/// </summary>
private void OnExecuteMaterialSelectionChangedCommand()
{
MaterialInfoModel materialInfo = MaterialInfoList.FirstOrDefault(m => m.Id == MaterialOutStorageInfo.MaterialID);
//
if (materialInfo != null)
{
MaterialOutStorageInfo.MaterialCode = materialInfo.MaterialCode;
MaterialOutStorageInfo.FullPalletQuantity = materialInfo.FullPalletQuantity;
}
else
{
MaterialOutStorageInfo.MaterialCode = null;
MaterialOutStorageInfo.FullPalletQuantity = null;
}
//
MaterialOutStorageInfoSetPalletQuantity.SetPalletQuantity(MaterialOutStorageInfo);
}
/// <summary>
/// 描述：获取物料信息
/// </summary>
/// <param name="materialId">物料Id</param>
/// <returns></returns>
public MaterialInfoModel GetMaterialById(int materialId)
{
var material = new MaterialInfoModel();
SqlParameter[] para =
{
new SqlParameter("@Id", materialId)
};
var sql = @"SELECT TOP 1 [Id]
,[MICustomerPart]
,[MIProductName]
,[MICustomer]
,[MIPicture]
,[MIIsValid]
,[MICreateUserId]
,[MICreateUserName]
,[MICreateTime]
,[MIOperateUserId]
,[MIOperateUserName]
,[MIOperateTime]
,[MIWorkOrder]
,[MIMaterial]
,[MIMaterialText]
,[MITool]
,[MITotalQty]
FROM " + tableName + " WHERE Id=@Id";
var ds = SqlHelper.ExecuteDataSet(CommandType.Text, sql.ToString(), null, para);
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = new DataTable();
dt = ds.Tables[0];
material = DataConvertHelper.DataTableToList <MaterialInfoModel>(dt)[0];
}
else
{
return(null);
}
return(material);
}
/// <summary>
/// 描述:保存物料
/// </summary>
/// <param name="model"></param>
/// <param name="loginUser"></param>
/// <returns></returns>
public static MaterialViewModel SaveMaterial(MaterialInfoModel model, UserLoginInfo loginUser)
{
var result = new MaterialViewModel()
{
IsSuccess = true
};
try
{
//add
if (model.Id == 0)
{
model.MIIsValid = 1;
model.MICreateUserNo = loginUser.JobNum;
model.MICreateUserName = loginUser.UserName;
model.MICreateTime = DateTime.Now;
model.MIOperateUserNo = loginUser.JobNum;
model.MIOperateUserName = loginUser.UserName;
model.MIOperateTime = DateTime.Now;
model.Id = _materialDal.Insert(model);
result.Message = EncryptHelper.DesEncrypt(model.Id.ToString()); //TODO
result.data = model;
}
else
{
//Update
model.MIOperateUserNo = loginUser.JobNum;
model.MIOperateUserName = loginUser.UserName;
model.MIOperateTime = DateTime.Now;
_materialDal.Update(model);
result.Message = EncryptHelper.DesEncrypt(model.Id.ToString()); //TODO
result.data = model;
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(result);
}
public bool Update(MaterialInfoModel model)
{
var sql = @"UPDATE " + tableName +
@" SET [MICustomerPart] = @MICustomerPart
,[MIProductName] = @MIProductName
,[MICustomer] = @MICustomer
,[MIPicture] = @MIPicture
,[MIIsValid] = @MIIsValid
,[MIOperateUserId] = @MIOperateUserId
,[MIOperateUserName] = @MIOperateUserName
,[MIOperateTime] = @MIOperateTime
,[MIWorkOrder] = @MIWorkOrder
,[MIMaterial] = @MIMaterial
,[MIMaterialText] = @MIMaterialText
,[MITool] = @MITool
,[MITotalQty] = @MITotalQty WHERE Id = @Id";
SqlParameter[] para =
{
new SqlParameter("@Id", model.Id),
new SqlParameter("@MICustomerPart", model.MICustomerPart),
new SqlParameter("@MIProductName", model.MIProductName),
new SqlParameter("@MICustomer", model.MICustomer),
new SqlParameter("@MIPicture", model.MIPicture),
new SqlParameter("@MIIsValid", model.MIIsValid),
new SqlParameter("@MIOperateUserId", model.MIOperateUserId),
new SqlParameter("@MIOperateUserName", model.MIOperateUserName),
new SqlParameter("@MIOperateTime", model.MIOperateTime),
new SqlParameter("@MIWorkOrder", model.MIWorkOrder),
new SqlParameter("@MIMaterial", model.MIMaterial),
new SqlParameter("@MIMaterialText", model.MIMaterialText),
new SqlParameter("@MITool", model.MITool),
new SqlParameter("@MITotalQty", model.MITotalQty),
};
return(SqlHelper.ExecteNonQuery(CommandType.Text, sql, null, para) > 0);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(MaterialInfoModel model)
{
var sql = @"INSERT INTO " + tableName +
"([MICustomerPart],[MIProductName],[MICustomer],[MIPicture],[MIIsValid],[MICreateUserId],[MICreateUserName],[MICreateTime],[MIOperateUserId],[MIOperateUserName],[MIOperateTime],[MIWorkOrder],[MIMaterial],[MIMaterialText],[MITool],[MITotalQty])" +
" VALUES (@MICustomerPart,@MIProductName,@MICustomer,@MIPicture,@MIIsValid,@MICreateUserId,@MICreateUserName,@MICreateTime,@MIOperateUserId,@MIOperateUserName,@MIOperateTime,@MIWorkOrder,@MIMaterial,@MIMaterialText,@MITool,@MITotalQty) " +
" select id = scope_identity()";
SqlParameter[] para =
{
new SqlParameter("@MICustomerPart", model.MICustomerPart),
new SqlParameter("@MIProductName", model.MIProductName),
new SqlParameter("@MICustomer", model.MICustomer),
new SqlParameter("@MIPicture", model.MIPicture),
new SqlParameter("@MIIsValid", model.MIIsValid),
new SqlParameter("@MICreateUserId", model.MICreateUserId),
new SqlParameter("@MICreateUserName", model.MICreateUserName),
new SqlParameter("@MICreateTime", model.MICreateTime),
new SqlParameter("@MIOperateUserId", model.MIOperateUserId),
new SqlParameter("@MIOperateUserName", model.MIOperateUserName),
new SqlParameter("@MIOperateTime", model.MIOperateTime),
new SqlParameter("@MIWorkOrder", model.MIWorkOrder),
new SqlParameter("@MIMaterial", model.MIMaterial),
new SqlParameter("@MIMaterialText", model.MIMaterialText),
new SqlParameter("@MITool", model.MITool),
new SqlParameter("@MITotalQty", model.MITotalQty),
};
var result = 0;
var ds = SqlHelper.ExecuteDataSet(CommandType.Text, sql.ToString(), null, para);
if (ds != null && ds.Tables.Count > 0)
{
var Idstring = ds.Tables[0].Rows[0][0].ToString();
result = string.IsNullOrEmpty(Idstring) ? 0 : Convert.ToInt32(Idstring);
}
return(result);
}
public ActionResult UpLoadFile(HttpPostedFileBase file)
{
StringBuilder strbuild = new StringBuilder();
string FileName;
string savePath;
if (file == null || file.ContentLength <= 0)
{
ViewBag.error = "文件不能为空";
return(View());
}
else
{
string fileName = Path.GetFileName(file.FileName);
int filesize = file.ContentLength; //获取上传文件的大小单位为字节byte
string fileEx = Path.GetExtension(fileName); //获取上传文件的扩展名
string NoFileName = Path.GetFileNameWithoutExtension(fileName); //获取无扩展名的文件名
int Maxsize = 4000 * 1024; //定义上传文件的最大空间大小为4M
string FileType = ".xls,.xlsx"; //定义上传文件的类型字符串
FileName = NoFileName + fileEx;
if (!FileType.Contains(fileEx))
{
ViewBag.error = "文件类型不对，只能导入xls和xlsx格式的文件";
return(View());
}
if (filesize >= Maxsize)
{
ViewBag.error = "上传文件超过4M，不能上传";
return(View());
}
string path = Server.MapPath("~/App_Data/uploads");
savePath = Path.Combine(path, FileName);
file.SaveAs(savePath);
}
string strConn;
strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + savePath + ";Extended Properties=Excel 12.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter("select * from [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
try
{
myCommand.Fill(myDataSet, "ExcelInfo");
}
catch (Exception ex)
{
ViewBag.error = ex.Message;
return(View());
}
DataTable table = myDataSet.Tables["ExcelInfo"].DefaultView.ToTable();
//引用事务机制，出错时，事物回滚
using (TransactionScope transaction = new TransactionScope())
{
for (int i = 0; i < table.Rows.Count; i++)
{
MaterialInfoModel model = new MaterialInfoModel();
model.MICustomerPart = table.Rows[i][0].ToString();
model.MIProductName = table.Rows[i][1].ToString();
model.MICustomer = table.Rows[i][2].ToString();
model.MIPicture = table.Rows[i][3].ToString();
model.MIIsValid = Convert.ToInt32(table.Rows[i][4].ToString());
model.MICreateUserId = 33029;
model.MICreateUserName = "******";
model.MICreateTime = DateTime.Now;
model.MIOperateUserId = 33029;
model.MIOperateUserName = "******";
model.MIOperateTime = DateTime.Now;
model.MIWorkOrder = table.Rows[i][5].ToString();
model.MIMaterial = table.Rows[i][6].ToString();
model.MIMaterialText = table.Rows[i][7].ToString();
model.MITool = table.Rows[i][8].ToString();
model.MITotalQty = Convert.ToInt32(table.Rows[i][9].ToString());
//_stationRepository.AddStation(station);
//Todo Inter DB
}
transaction.Complete();
}
//ViewBag.error = "导入成功";
System.Threading.Thread.Sleep(2000);
return(RedirectToAction("MaterialIndex"));
}
public ActionResult AddOrUpdate(MaterialInfoModel model)
{
var result = MaterialBusiness.SaveNewMaterial(model, this.LoginUser);
return(Json(result));
}
public ActionResult MaterialOperate(MaterialInfoModel model)
{
var result = MaterialBusiness.SaveMaterial(model, this.LoginUser);
return(Json(result));
}
/// <summary>
/// Test
/// </summary>
/// <param name="file"></param>
/// <returns></returns>
public ActionResult UploadMaterialFiles()
{
var result = new ResultInfoModel()
{
IsSuccess = false
};
StringBuilder strbuild = new StringBuilder();
string FileName;
string savePath;
HttpPostedFileBase file = Request.Files["file"];
if (file == null || file.ContentLength <= 0)
{
result.Message = "please choose file";
return(Content(JsonHelper.JsonSerializer(result)));
}
else
{
string fileName = Path.GetFileName(file.FileName);
int filesize = file.ContentLength; //获取上传文件的大小单位为字节byte
string fileEx = Path.GetExtension(fileName); //获取上传文件的扩展名
string NoFileName = Path.GetFileNameWithoutExtension(fileName); //获取无扩展名的文件名
int Maxsize = 4000 * 1024; //定义上传文件的最大空间大小为4M
string FileType = ".xls,.xlsx"; //定义上传文件的类型字符串
FileName = NoFileName + fileEx;
if (!FileType.Contains(fileEx))
{
result.Message = "please upload .xls and .xlsx";
return(Content(JsonHelper.JsonSerializer(result)));
}
if (filesize >= Maxsize)
{
result.Message = string.Format("file size can't big than {0}", Maxsize);
return(Content(JsonHelper.JsonSerializer(result)));
}
string path = Server.MapPath("~/App_Data/uploads");
savePath = Path.Combine(path, FileName);
file.SaveAs(savePath);
string strConn;
strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + savePath + ";Extended Properties=Excel 12.0;";
using (OleDbConnection conn = new OleDbConnection(strConn))
{
conn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter("select * from [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
try
{
myCommand.Fill(myDataSet, "ExcelInfo");
}
catch (Exception ex)
{
result.Message = ex.Message;
return(Content(JsonHelper.JsonSerializer(result)));
}
DataTable table = myDataSet.Tables["ExcelInfo"].DefaultView.ToTable();
try
{
for (int i = 0; i < table.Rows.Count; i++)
{
MaterialInfoModel model = new MaterialInfoModel();
model.MIProcessType = table.Rows[i][0].ToString();
model.MICustomer = table.Rows[i][1].ToString();
model.MISapPN = table.Rows[i][2].ToString();
model.MIProductName = table.Rows[i][3].ToString();
model.MIInjectionMC = table.Rows[i][4].ToString();
model.MICustomerPN = table.Rows[i][5].ToString();
model.MICavity = DataConvertHelper.ToInt(table.Rows[i][6].ToString(), 0);
model.MICycletime = DataConvertHelper.ToDecimal(table.Rows[i][7].ToString(), 0);
model.MICycletimeCav = DataConvertHelper.ToDecimal(table.Rows[i][8].ToString(), 0);
model.MIStandardHeadcount = DataConvertHelper.ToInt(table.Rows[i][9].ToString(), 0);
model.MTStandardScrap = table.Rows[i][10].ToString();
model.MIMaterialPN = table.Rows[i][11].ToString();
model.MICavityG = DataConvertHelper.ToDecimal(table.Rows[i][12].ToString(), 0);
model.MIMoldNo = table.Rows[i][13].ToString();
model.MIAssAC = table.Rows[i][14].ToString();
model.MIWorkOrder = table.Rows[i][15].ToString();
MaterialBusiness.SaveMaterial(model, this.LoginUser);
var insertResult = MaterialBusiness.SaveMaterial(model, LoginUser);
}
result.IsSuccess = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
return(Content(JsonHelper.JsonSerializer(result)));
}
conn.Close();
}
return(Content(JsonHelper.JsonSerializer(result)));
}
}
