/// <summary> /// 删除选中的项目 /// </summary> /// <param name="select"></param> public void DeleteStoreStruct(params string[] select) { using (StoreAccess access = new StoreAccess(true)) { string strSQL = string.Empty; try { access.Open(); access.BeginTransaction(); if (select[0] == "全部删除") { strSQL = access.CommandFormate("DELETE FROM [dbo].[Table_Warehouse]"); access.Delete(strSQL); } else { strSQL = access.CommandFormate("DELETE FROM [dbo].[Table_Warehouse] WHERE [Row] = {0}Row AND [Column] = {0}Column AND [Layer] = {0}Layer"); access.Delete(strSQL, parmater => { parmater.Add(parmater.CreateParameter("Row", select[1])); parmater.Add(parmater.CreateParameter("Column", select[2])); parmater.Add(parmater.CreateParameter("Layer", select[3])); }); } access.Commit(); } catch (DbException dbe) { LogBusiness.RecordLog("管理员", dbe.Message, "删除仓库结构数据操作异常"); } } }
/// <summary> /// 必须按照格式【什么人,干什么事,什么类型】 /// </summary> /// <param name="log"></param> public static void RecordLog(string logs1, string logs2, string logs3) { using (StoreAccess access = new StoreAccess(true)) { try { string strSQL = access.CommandFormate("INSERT INTO [Table_Log] ([Logtime] ,[LogUser],[Remark],[Type]) VALUES ({0}Logtime,{0}LogUser,{0}Remark,{0}Type)"); access.Open(); access.BeginTransaction(); access.Insert(strSQL, parmater => { parmater.Add(parmater.CreateParameter("Logtime", DateTime.Now)); parmater.Add(parmater.CreateParameter("LogUser", logs1)); parmater.Add(parmater.CreateParameter("Remark", logs2)); parmater.Add(parmater.CreateParameter("Type", logs3)); }); access.Commit(); } catch (DbException db) { access.RollBack(); access.Close(); } } }
/// <summary> /// 仓库结构修改 /// </summary> public int StoreStructUpdate(params string[] store) { int count = 0; using (StoreAccess access = new StoreAccess(true)) { try { access.Open(); access.BeginTransaction(); string strSQL = access.CommandFormate("UPDATE [dbo].[Table_Warehouse] SET [StoreStaus] = {0}StoreStaus,[Type]={0}Type WHERE [Row]={0}Row AND [Column]={0}Column AND [Layer]={0}Layer"); count = access.Update(strSQL, (parmarter) => { parmarter.Add(parmarter.CreateParameter("StoreStaus", store[0])); parmarter.Add(parmarter.CreateParameter("Type", store[1])); parmarter.Add(parmarter.CreateParameter("Row", store[2])); parmarter.Add(parmarter.CreateParameter("Column", store[3])); parmarter.Add(parmarter.CreateParameter("Layer", store[4])); }); access.Commit(); } catch (DbException ex) { LogBusiness.RecordLog("管理员", ex.Message, "修改仓库结构数据操作异常"); access.RollBack(); access.Close(); } } return(count); }
/// <summary> /// 获得账户信息 /// </summary> /// <param name="userAcount"></param> /// <returns></returns> public List <User> GetUserForAcount(object userAcount) { using (StoreAccess access = new StoreAccess()) { string strSQL = access.CommandFormate("SELECT [Name],[Remark],[Access] FROM [Table_User] WHERE Id = {0}Id"); return(access.ExcuteSelect <User>(strSQL, parameter => { parameter.Add(parameter.CreateParameter("Id", Convert.ToInt32(userAcount))); })); } }
/// <summary> /// 通过物料编码获取相关信息 /// </summary> /// <param name="materialNumber">物料编码</param> /// <param name="code">到货编号</param> /// <returns></returns> public List <InvoiceVerify> GetMaterialMaeeage(string materialNumber, string code) { using (StoreAccess access = new StoreAccess()) { string strSQL = access.CommandFormate("SELECT * FROM [Table_InvoiceVerify] WHERE [InvoiceNumber] = {0}InvoiceNumber AND [MaterialNumber] = {0}MaterialNumber"); return(access.ExcuteSelect <InvoiceVerify>(strSQL, parmater => { parmater.Add(parmater.CreateParameter("InvoiceNumber", code)); parmater.Add(parmater.CreateParameter("MaterialNumber", materialNumber)); })); } }
/// <summary> /// 创建仓库 /// </summary> /// <param name="starStoreUnit">起始位置</param> /// <param name="endStoreUnit">终止位置</param> /// <param name="type">仓库类型</param> /// <returns>创建成功与否</returns> public bool CreatStroe(string starStoreUnit, string endStoreUnit, int type) { bool result = false; string[] unitStar = starStoreUnit.Split('-'); string[] unitEnd = endStoreUnit.Split('-'); int rowStar = Convert.ToInt16(unitStar[0]); int columnStar = (int)Convert.ToChar(unitStar[1]) - 64; int layerStar = Convert.ToInt16(unitStar[2]); int rowEnd = Convert.ToInt16(unitEnd[0]); int columnEnd = (int)Convert.ToChar(unitEnd[1]) - 64; int layerEnd = Convert.ToInt16(unitEnd[2]); if (rowStar > rowEnd || columnStar > columnEnd || layerStar > layerEnd) { MessageBox.Show("所填写的信息不正确,请重新填写"); return(false); } string[] store = new string[(rowEnd - rowStar + 1) * (columnEnd - columnStar + 1) * (layerEnd - layerStar + 1)]; //if (rowStar == 1 && columnStar == 1 && layerStar == 1) //{ // for (int i = 0; i < rowEnd; i++) // { // for (int j = 0; j < columnEnd; j++) // { // for (int k = 0; k < layerEnd; k++) // { // store[i * columnEnd * layerEnd + j * layerEnd + k] = string.Format("{0}-{1}-{2}", i + 1, Convert.ToChar(j + 65), k + 1); // } // } // } //} //else for (int i = 0; i < rowEnd - rowStar + 1; i++) { for (int j = 0; j < columnEnd - columnStar + 1; j++) { for (int k = 0; k < layerEnd - layerStar + 1; k++) { store[i * (columnEnd - columnStar + 1) * layerEnd + j * (layerEnd - layerStar + 1) + k] = string.Format("{0}-{1}-{2}", rowStar + i, Convert.ToChar(columnStar + j + 64), layerStar + k); } } } using (StoreAccess access = new StoreAccess(true)) { try { access.Open(); access.BeginTransaction(); for (int i = 0; i < store.Length; i++) { string[] storeParameter = store[i].Split('-'); string sql = access.CommandFormate("INSERT INTO [dbo].[Table_Warehouse]([Row],[Column],[Layer],[StoreStaus],[MaxCount],[Status],[Type]) VALUES({0}Row,{0}Column,{0}Layer,{0}StoreStaus,{0}MaxCount,{0}Status,{0}Type)"); access.Insert(sql, (parameter) => { parameter.Add(parameter.CreateParameter("Row", storeParameter[0])); parameter.Add(parameter.CreateParameter("Column", storeParameter[1])); parameter.Add(parameter.CreateParameter("Layer", storeParameter[2])); parameter.Add(parameter.CreateParameter("StoreStaus", 0)); parameter.Add(parameter.CreateParameter("MaxCount", 20000)); parameter.Add(parameter.CreateParameter("Status", 0)); parameter.Add(parameter.CreateParameter("Type", type)); }); } access.Commit(); result = true; } catch (DbException ex) { LogBusiness.RecordLog("管理员", ex.Message, "创建仓库结构数据操作异常"); access.RollBack(); access.Close(); } } return(result); }