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 int AddSpecialRequest(LabelPrintSpecialRequestModel model) { return(Convert.ToInt32(dal.AddSpecialRequest(model))); }