/// <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);
}