public object AddSpecialRequest(LabelPrintSpecialRequestModel model)
{
return(SqlHelper.ExecuteScalar(@" insert into SJPrintCustLabelSpecialRequest(OrgID,Label,RequestSeq,RequestName,RequestValue,IdentityType,IdentityTypeDesc)
values(@OrgID,@Label,@RequestSeq,@RequestName,@RequestValue,@IdentityType,@IdentityTypeDesc);
SELECT @@IDENTITY AS R;"
, new SqlParameter[] {
new SqlParameter("@OrgID", model.OrgID),
new SqlParameter("@Label", model.Label),
new SqlParameter("@RequestSeq", model.RequestSeq),
new SqlParameter("@RequestName", model.RequestName),
new SqlParameter("@RequestValue", SqlHelper.ConvertNullableStringToDbValue(model.RequestValue)),
new SqlParameter("@IdentityType", model.IdentityType),
new SqlParameter("@IdentityTypeDesc", model.IdentityTypeDesc),
//new SqlParameter("@IsFixedValue", model.IsFixedValue)
}));
}
public object AddCommonAdjustment(LabelPrintCommonAdjustmentModel model)
{
return(SqlHelper.ExecuteScalar(@" INSERT INTO dbo.SJPrintCustLabelCommonAdjustment(OrgID,Label,ProductionName,ExpirationMonth,ExpirationDay,IdentityType,IdentityTypeDesc,NetWeight)
VALUES( @OrgID,@Label,@ProductionName,@ExpirationMonth,@ExpirationDay,@IdentityType,@IdentityTypeDesc,@NetWeight );
SELECT @@IDENTITY AS R"
, new SqlParameter[] {
new SqlParameter("@OrgID", model.OrgID),
new SqlParameter("@Label", model.Label),
new SqlParameter("@ProductionName", SqlHelper.ConvertNullableStringToDbValue(model.ProductionName)),
new SqlParameter("@ExpirationMonth", SqlHelper.ConvertNullableIntToDbValue(model.ExpirationMonth)),
new SqlParameter("@ExpirationDay", SqlHelper.ConvertNullableIntToDbValue(model.ExpirationDay)),
new SqlParameter("@IdentityType", model.IdentityType),
new SqlParameter("@IdentityTypeDesc", model.IdentityTypeDesc),
new SqlParameter("@NetWeight", model.NetWeight)
}));
}
public int UpdateCommonAdjustment(LabelPrintCommonAdjustmentModel model)
{
return(SqlHelper.ExecuteNonQuery(@" Update dbo.SJPrintCustLabelCommonAdjustment "
+ " SET OrgID=@OrgID, "
+ " Label=@Label, "
+ " ProductionName =@ProductionName, "
+ " ExpirationMonth =@ExpirationMonth, "
+ " ExpirationDay =@ExpirationDay, "
+ " IdentityType =@IdentityType, "
+ " IdentityTypeDesc =@IdentityTypeDesc ,"
+ " NetWeight =@NetWeight "
+ " WHERE ID=@ID"
, new SqlParameter[] {
new SqlParameter("@ID", model.ID),
new SqlParameter("@OrgID", model.OrgID),
new SqlParameter("@Label", model.Label),
new SqlParameter("@ProductionName", SqlHelper.ConvertNullableStringToDbValue(model.ProductionName)),
new SqlParameter("@ExpirationMonth", SqlHelper.ConvertNullableIntToDbValue(model.ExpirationMonth)),
new SqlParameter("@ExpirationDay", SqlHelper.ConvertNullableIntToDbValue(model.ExpirationDay)),
new SqlParameter("@IdentityType", model.IdentityType),
new SqlParameter("@IdentityTypeDesc", model.IdentityTypeDesc),
new SqlParameter("@NetWeight", model.NetWeight)
}));
}
public int UpdateLabelPrintSpecialRequestModel(int id, string value, string label)
{
return(SqlHelper.ExecuteNonQuery(" update SJPrintCustLabelSpecialRequest set RequestValue=@RequestValue,Label=@Label where id=@id ;"
, new SqlParameter[] { new SqlParameter("@id", id),
new SqlParameter("@RequestValue", SqlHelper.ConvertNullableStringToDbValue(value)),
new SqlParameter("@Label", SqlHelper.ConvertNullableStringToDbValue(label)) }));
}
