コード例 #1
0
        internal int EditOrderApplyReq_Application(Api_hzins_OrderApplyReq_Application m)
        {
            //暂时只有录入保险请求,没有修改保险请求的操作
            if (m.id > 0)
            {
                return(0);
            }
            else
            {
                string sql = @"INSERT INTO  [api_hzins_OrderApplyReq_Application]
                                       ([applicationDate]
                                       ,[startDate]
                                       ,[endDate]
                                       ,[singlePrice]
                                       ,[orderid])
                                 VALUES
                                       (@applicationDate
                                       ,@startDate
                                       ,@endDate
                                       ,@singlePrice
                                       ,@orderid);select @@identity;";
                var    cmd = sqlHelper.PrepareTextSqlCommand(sql);
                cmd.AddParam("@applicationDate", m.applicationDate);
                cmd.AddParam("@startDate", m.startDate);
                cmd.AddParam("@endDate", m.endDate);
                cmd.AddParam("@singlePrice", m.singlePrice);
                cmd.AddParam("@orderid", m.orderid);

                object o = cmd.ExecuteScalar();
                return(int.Parse(o.ToString()));
            }
        }
コード例 #2
0
 public int EditOrderApplyReq_Application(Api_hzins_OrderApplyReq_Application m)
 {
     using (var helper = new SqlHelper())
     {
         int r = new Internalapi_hzins_OrderApplyReq_Application(helper).EditOrderApplyReq_Application(m);
         return(r);
     }
 }
コード例 #3
0
        internal Api_hzins_OrderApplyReq_Application GetOrderApplyReq_Application(int orderid)
        {
            string sql = "select * from api_hzins_OrderApplyReq_Application where orderid=" + orderid;
            var    cmd = sqlHelper.PrepareTextSqlCommand(sql);

            using (var reader = cmd.ExecuteReader())
            {
                Api_hzins_OrderApplyReq_Application m = null;
                if (reader.Read())
                {
                    m = new Api_hzins_OrderApplyReq_Application
                    {
                        id = reader.GetValue <int>("id"),
                        applicationDate = reader.GetValue <string>("applicationDate"),
                        startDate       = reader.GetValue <string>("startDate"),
                        endDate         = reader.GetValue <string>("endDate"),
                        singlePrice     = reader.GetValue <decimal>("singlePrice"),
                        orderid         = reader.GetValue <int>("orderid")
                    };
                }
                return(m);
            }
        }