public bool InsertComponentTray(LotCustomerModel model)
{
bool isBool = false;
try
{
_errorMsg = string.Empty;
IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject();
isBool = serverFactory.CreateILotComponentTrayEngine().InsertComponentTray(model);
}
catch (Exception ex)
{
_errorMsg = ex.Message;
}
finally
{
CallRemotingService.UnregisterChannel();
}
return(isBool);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InsertComponentTray(LotCustomerModel model)
{
int count = 0;
bool isBool = false;
using (DbConnection dbconn = db.CreateConnection())
{
dbconn.Open();
DbTransaction dbTrans = dbconn.BeginTransaction();
try
{
StringBuilder sbSql = new StringBuilder();
sbSql.Append("INSERT INTO dbo.POR_COMPONENT_TRAY_LIST ");
sbSql.Append(" ( TrayName ,TrayValue ,LotNumber ,LineKey ,LineName ,PackageNumber ,Number ,Color ,PsKey ,SubPowerlevel ,WorkOrderNo ,PatrNumber ,GradeName ,CreateTime,VirtualCustomerNumber,IsFlip,IsPack)");
sbSql.Append(" VALUES ");
sbSql.Append("(@TrayName ,@TrayValue ,@LotNumber ,@LineKey ,@LineName ,@PackageNumber ,@Number ,@Color ,@PsKey ,@SubPowerlevel ,@WorkOrderNo ,@PatrNumber ,@GradeName ,@CreateTime,@VirtualCustomerNumber,@IsFlip,@IsPack)");
SqlParameter[] parameters =
{
new SqlParameter("@TrayName", SqlDbType.VarChar, 50),
new SqlParameter("@TrayValue", SqlDbType.VarChar, 50),
new SqlParameter("@LotNumber", SqlDbType.VarChar, 50),
new SqlParameter("@LineKey", SqlDbType.VarChar, 50),
new SqlParameter("@LineName", SqlDbType.VarChar, 50),
new SqlParameter("@PackageNumber", SqlDbType.VarChar, 50),
new SqlParameter("@Number", SqlDbType.VarChar, 50),
new SqlParameter("@Color", SqlDbType.VarChar, 50),
new SqlParameter("@PsKey", SqlDbType.VarChar, 50),
new SqlParameter("@SubPowerlevel", SqlDbType.VarChar, 50),
new SqlParameter("@WorkOrderNo", SqlDbType.VarChar, 50),
new SqlParameter("@PatrNumber", SqlDbType.VarChar, 50),
new SqlParameter("@GradeName", SqlDbType.VarChar, 50),
new SqlParameter("@CreateTime", SqlDbType.VarChar, 50),
new SqlParameter("@VirtualCustomerNumber", SqlDbType.VarChar, 50),
new SqlParameter("@IsFlip", SqlDbType.VarChar, 50),
new SqlParameter("@IsPack", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.TrayText;
parameters[1].Value = model.TrayValue;
parameters[2].Value = model.LotNumber;
parameters[3].Value = model.LineKey;
parameters[4].Value = model.LineName;
parameters[5].Value = model.PackageNumber;
parameters[6].Value = model.Number;
parameters[7].Value = model.Color;
parameters[8].Value = model.PsKey;
parameters[9].Value = model.SubPowerlevel;
parameters[10].Value = model.WorkOrderNo;
parameters[11].Value = model.PatrNumber;
parameters[12].Value = model.GradeName;
parameters[13].Value = DateTime.Now.ToString();
parameters[14].Value = model.VirtualCustomerNumber;
parameters[15].Value = model.IsFlip;
parameters[16].Value = model.IsPack;
DbCommand com = db.GetSqlStringCommand(sbSql.ToString()); //初始化command
for (int i = 0; i < parameters.Length; i++) //参数填充
{
db.AddInParameter(com, parameters[i].ParameterName, parameters[i].DbType, parameters[i].Value);
}
count = db.ExecuteNonQuery(com); //执行
if (count > 0)
{
isBool = true;
}
dbTrans.Commit();
}
catch (Exception ex)
{
dbTrans.Rollback();
throw ex;
}
finally
{
dbTrans.Dispose();
dbconn.Close();
dbconn.Dispose();
}
}
return(isBool);
}
