public bool InsertTScanLabel(string @Customer, string @Part_Id, string @Part_No, string @Part_Name, Decimal @Pack_Qty, string @Rank_No, string @Issue_No, string @Serial_No, string @Order_No, string @CreateBy, string @UNIQUEID, string RanNo = "", string @Label_Id = "")
{
bool success = true;
int rownum = 0;
try
{
BeginTransaction();
SqlComm.CommandType = CommandType.StoredProcedure;
SqlComm.CommandText = "spInsTScanLabel";
SqlComm.Parameters.Clear();
SqlComm.Parameters.Add(new SqlParameter("@Customer", SqlDbType.VarChar));
SqlComm.Parameters.Add(new SqlParameter("@Part_Id", SqlDbType.VarChar));
SqlComm.Parameters.Add(new SqlParameter("@Part_No", SqlDbType.VarChar));
SqlComm.Parameters.Add(new SqlParameter("@Part_Name", SqlDbType.VarChar));
SqlComm.Parameters.Add(new SqlParameter("@Pack_Qty", SqlDbType.Decimal));
SqlComm.Parameters.Add(new SqlParameter("@Rank_No", SqlDbType.VarChar));
SqlComm.Parameters.Add(new SqlParameter("@Issue_No", SqlDbType.VarChar));
SqlComm.Parameters.Add(new SqlParameter("@Serial_No", SqlDbType.VarChar));
SqlComm.Parameters.Add(new SqlParameter("@Order_No", SqlDbType.VarChar));
SqlComm.Parameters.Add(new SqlParameter("@CreateBy", SqlDbType.VarChar));
SqlComm.Parameters.Add(new SqlParameter("@UNIQUEID", SqlDbType.VarChar));
SqlComm.Parameters.Add(new SqlParameter("@RanNo", SqlDbType.VarChar));
SqlComm.Parameters.Add(new SqlParameter("@Label_Id", SqlDbType.VarChar));
SqlComm.Parameters["@Customer"].Value = @Customer;
SqlComm.Parameters["@Part_Id"].Value = @Part_Id;
SqlComm.Parameters["@Part_No"].Value = @Part_No;
SqlComm.Parameters["@Part_Name"].Value = @Part_Name;
SqlComm.Parameters["@Pack_Qty"].Value = @Pack_Qty;
SqlComm.Parameters["@Rank_No"].Value = @Rank_No;
SqlComm.Parameters["@Issue_No"].Value = @Issue_No;
SqlComm.Parameters["@Serial_No"].Value = @Serial_No;
SqlComm.Parameters["@Order_No"].Value = @Order_No;
SqlComm.Parameters["@CreateBy"].Value = @CreateBy;
SqlComm.Parameters["@UNIQUEID"].Value = @UNIQUEID;
SqlComm.Parameters["@RanNo"].Value = @RanNo;
SqlComm.Parameters["@Label_Id"].Value = @Label_Id;
SqlComm.CommandTimeout = 0;
rownum = SqlComm.ExecuteNonQuery();
success = (rownum > 0) ? true : false;
if (success)
{
CommitTransaction();
}
else
{
RollbackTrasaction();
}
}
catch (Exception ex)
{
success = false;
RollbackTrasaction();
}
finally
{
CloseConnection();
}
return(success);
}
