コード例 #1
0
 /// <summary>
 /// 添加预约
 /// </summary>
 /// <param name="model">预约实体</param>
 /// <returns></returns>
 public bool AddAppointmentOrderInfo(AppointmentOrderInfoEntity model)
 {
     AdjDBObject adjDbObject = new AdjDBObject();
     bool isok = true;
     try
     {
         adjDbObject.GetStoredProcCommand("sp3_D_AppointmentOrderInfo_i");
         adjDbObject.AddOutParameter("@Id", DbType.Int32, 4);
         adjDbObject.AddInParameter("@AppointOrderId", DbType.String, model.AppointOrderId);
         adjDbObject.AddInParameter("@OrderId", DbType.String, model.OrderId);
         adjDbObject.AddInParameter("@AppointOrderType", DbType.Int32, model.AppointOrderType);
         adjDbObject.AddInParameter("@AppointOrderState", DbType.Int32, model.AppointOrderState);
         adjDbObject.AddInParameter("@BusinessType", DbType.Int32, model.BusinessType);
         adjDbObject.AddInParameter("@AppointOrderFrom", DbType.Int32, model.AppointOrderFrom);
         adjDbObject.AddInParameter("@CustomerId", DbType.String, model.CustomerId);
         adjDbObject.AddInParameter("@CustomerName", DbType.String, model.CustomerName);
         adjDbObject.AddInParameter("@CustomerType", DbType.Int32, model.CustomerType);
         adjDbObject.AddInParameter("@AccountType", DbType.Int32, model.AccountType);
         adjDbObject.AddInParameter("@Cellphone", DbType.String, model.Cellphone);
         adjDbObject.AddInParameter("@FromCellphone", DbType.String, model.FromCellphone);
         adjDbObject.AddInParameter("@AppointAddress", DbType.String, model.AppointAddress);
         adjDbObject.AddInParameter("@AppointTimeStr", DbType.String, model.AppointTimeStr);
         adjDbObject.AddInParameter("@AppointTime", DbType.DateTime, model.AppointTime);
         //adjDbObject.AddInParameter("@EstimateEndTime", DbType.DateTime, model.EstimateEndTime);
         adjDbObject.AddInParameter("@IsLock", DbType.Boolean, false);
         adjDbObject.AddInParameter("@LockUser", DbType.String, model.LockUser);
         adjDbObject.AddInParameter("@partyId", DbType.Int32, model.PartyId);
         adjDbObject.AddInParameter("@SendOrderUser", DbType.String, model.SendOrderUser);
         adjDbObject.AddInParameter("@AppointOrderSign", DbType.String, model.AppointOrderSign);
         adjDbObject.AddInParameter("@PhoneCallTime", DbType.Int32, model.PhoneCallTime);
         adjDbObject.AddInParameter("@lng", DbType.Double, model.Lng);
         adjDbObject.AddInParameter("@lat", DbType.Double, model.Lat);
         adjDbObject.AddInParameter("@create_time", DbType.DateTime, model.Create_time);
         adjDbObject.AddInParameter("@create_user", DbType.String, model.Create_user);
         //adjDbObject.AddInParameter("@update_time", DbType.DateTime, model.Update_time);
         // adjDbObject.AddInParameter("@update_user", DbType.String, model.Update_user);
         //adjDbObject.AddInParameter("@delete_time", DbType.DateTime, model.Delete_time);
         // adjDbObject.AddInParameter("@delete_user", DbType.String, model.Delete_user);
         // adjDbObject.AddInParameter("@delete_flag", DbType.Boolean, model.Delete_flag);
         adjDbObject.Execute();
     }
     catch (Exception ex)
     {
         isok = false;
     }
     return isok;
 }
コード例 #2
0
        public bool AddParterDyLog(T_ParterDyLog model)
        {
            AdjDBObject adjDbObject = new AdjDBObject();
            bool isok = true;
            try
            {
                adjDbObject.GetStoredProcCommand("sp3_T_ParterDyLog_i");
                adjDbObject.AddOutParameter("@id", DbType.Int32, 4);
                adjDbObject.AddInParameter("@sign", DbType.String, model.sign);
                adjDbObject.AddInParameter("@typeid", DbType.Int32, model.typeid);
                adjDbObject.AddInParameter("@imei", DbType.String, model.imei);
                adjDbObject.AddInParameter("@lat", DbType.String, model.lat);
                adjDbObject.AddInParameter("@lng", DbType.String, model.lng);
                adjDbObject.AddInParameter("@addtime", DbType.DateTime, model.addtime);
                adjDbObject.Execute();

            }
            catch (Exception ex)
            {
                isok = false;
            }
            return isok;
        }