コード例 #1
0
        public static int InsertConsignToAccLog(ConsignToAccLogEntity entity)
        {
            DataCommand command = DataCommandManager.GetDataCommand("InsertConsignToAccLog");

            command.SetParameterValue("@CompanyCode", entity.CompanyCode);
            command.SetParameterValue("@ConsignToAccType", entity.ConsignToAccType);
            command.SetParameterValue("@CreateCost", entity.CreateCost);
            command.SetParameterValue("@CreateTime", entity.CreateTime);
            command.SetParameterValue("@CurrencySysNo", entity.CurrencySysNo);
            command.SetParameterValue("@FoldCost", entity.FoldCost);
            command.SetParameterValue("@IsConsign", entity.IsConsign);
            command.SetParameterValue("@LanguageCode", entity.LanguageCode);
            command.SetParameterValue("@Note", entity.Note);
            command.SetParameterValue("@OrderSysNo", entity.OrderSysNo);
            command.SetParameterValue("@Point", entity.Point);
            command.SetParameterValue("@ProductSysNo", entity.ProductSysNo);
            command.SetParameterValue("@Quantity", entity.Quantity);
            command.SetParameterValue("@RetailPrice", entity.RetailPrice);
            command.SetParameterValue("@SettleCost", entity.SettleCost);
            command.SetParameterValue("@SettlePercentage", entity.SettlePercentage);
            command.SetParameterValue("@SettleType", entity.SettleType);
            command.SetParameterValue("@Status", entity.Status);
            command.SetParameterValue("@StockSysNo", int.Parse(entity.StockSysNo));
            command.SetParameterValue("@StoreCompanyCode", entity.StoreCompanyCode);
            command.SetParameterValue("@VendorSysNo", entity.VendorSysNo);

            return(Convert.ToInt32(command.ExecuteScalar()));
        }
コード例 #2
0
ファイル: Program.cs プロジェクト: sanlonezhang/ql
 private void SetDefaultPropertiesValue(ConsignToAccLogEntity entity)
 {
     if (entity == null)
     {
         return;
     }
     entity.CompanyCode      = ConfigurationManager.AppSettings["CompanyCode"];
     entity.StoreCompanyCode = ConfigurationManager.AppSettings["StoreCompanyCode"];
     entity.LanguageCode     = ConfigurationManager.AppSettings["LanguageCode"];
     entity.CreateTime       = DateTime.Now;
     entity.CurrencySysNo    = 1;
     entity.Note             = "Create By Job AutoCreateAccLog";
     entity.Status           = 0;
 }