示例#1
0
 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)
     }));
 }
示例#2
0
 public int AddSpecialRequest(LabelPrintSpecialRequestModel model)
 {
     return(Convert.ToInt32(dal.AddSpecialRequest(model)));
 }