/// <summary>
/// 唯一码是否存在
/// </summary>
/// <param name="uniqueCode">唯一码</param>
/// <param name="tableName"表名</param>
/// <returns></returns>
public bool IsExistsUniqueCode(string uniqueCode, string tableName, string oid = "")
{
lock (lockObj)
{
try
{
int count = 0;
StringBuilder queryStrbd = new StringBuilder();
queryStrbd.Append("select count(1) from ")
.Append(tableName)
.Append(" where UniqueCode='")
.Append(uniqueCode)
.Append("'");
if (!string.IsNullOrEmpty(oid))
{
queryStrbd.Append(" and Oid!=").Append(oid);
}
var countobj = new SQLiteHelper().ExecuteScalar(queryStrbd.ToString());
count = Int32.TryParse(countobj.ToString(), out count) ? count : 0;
return(count > 0);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 获取总记录数
/// </summary>
/// <param name="countSelectStr"></param>
/// <returns></returns>
public virtual int TotalCount(string countSelectStr)
{
int count = 0;
var countdt = new SQLiteHelper().ExecuteScalar(countSelectStr);
count = Int32.TryParse(countdt.ToString(), out count) ? count : 0;
return(count);
}
public string UploadItemCodeAndSNList(ItemCodeSN_UploadDTO value)
{
if (value == null || value.SNList == null || value.SNList.Count <= 0)
{
return("SN List is null !");
}
if (string.IsNullOrEmpty(value.RoNumber))
{
return("RoNumber is null !");
}
if (string.IsNullOrEmpty(value.ItemCode))
{
return("Raw Material Label isn't scanned !");
}
try
{
string roNumber = value.RoNumber;
string itemCode = value.ItemCode;
string itemName = string.Empty;
string finishedProductNum = value.FinishedProductNum;
List <ItemCodeSNDTO> snList = value.SNList;
#region 查询原材料备案
StringBuilder rawMaterialReaderStrbd = new StringBuilder();
rawMaterialReaderStrbd.Append(@"select m.Code from Material m where m.Name = @Name ");
SQLiteParameter[] readParameter = { SQLiteHelper.MakeSQLiteParameter("@Name", DbType.String, itemCode) };
object rawMaterialObject = new SQLiteHelper().ExecuteScalar(rawMaterialReaderStrbd.ToString(), readParameter);
if (rawMaterialObject == null)
{
return("Raw Material Name is empty !");
}
itemName = rawMaterialObject.ToString();
#endregion
#region 插入原材料SN列表
StringBuilder noQueryStrbd = new StringBuilder();
noQueryStrbd.Append(@"insert into ItemCodeSN (ItemCode,ItemName,FinishedProductNum,SerivalNum,RoNumber) ")
.Append(@"values ( ")
.Append(@"@ItemCode,@ItemName,@FinishedProductNum,@SerivalNum,@RoNumber ")
.Append(@") ");
List <SQLiteParameter[]> paramList = new List <SQLiteParameter[]>();
foreach (var dto in snList)
{
SQLiteParameter[] parameter =
{
SQLiteHelper.MakeSQLiteParameter("@ItemCode", DbType.String, dto.ItemCode),
SQLiteHelper.MakeSQLiteParameter("@ItemName", DbType.String, itemName),
SQLiteHelper.MakeSQLiteParameter("@FinishedProductNum", DbType.String, finishedProductNum),
SQLiteHelper.MakeSQLiteParameter("@SerivalNum", DbType.String, dto.SerivalNum),
SQLiteHelper.MakeSQLiteParameter("@RoNumber", DbType.String, roNumber)
};
paramList.Add(parameter);
}
new SQLiteHelper().ExecuteNonQueryBatch(noQueryStrbd.ToString(), paramList);
#endregion
return(string.Empty);
}
catch (Exception ex)
{
LogHelper.WriteLog("UploadItemCodeAndSNList", ex);
return(ex.Message);
}
}