private void Key_01_Modify_Car(dynamic data) { string _openId = _http.Session["OpenId"].ToString(); CT_Car_Inventory _car_In = new CT_Car_Inventory(); if (data.CI_AU_Code == null) { _car_In.CI_AU_Code = getWechat_Member(_openId).MB_AU_Code; } else { _car_In.CI_AU_Code = (long)data.CI_AU_Code; } _car_In.CI_CS_Code = (int)data.CI_CS_Code; _car_In.CI_VIN = null; _car_In.CI_Mileage = null; _car_In.CI_Licence = data.CI_Licence; _car_In.CI_Licence_dt = null; if (!string.IsNullOrEmpty((string)data.CI_Licence_dt)) { _car_In.CI_Licence_dt = Convert.ToDateTime(data.CI_Licence_dt); } _car_In.CI_YR_Code = null; _car_In.CI_Color_I = null; _car_In.CI_Color_E = null; _car_In.CI_Picture_FN = null; _car_In.CI_Status = "1"; _car_In.CI_Activate_Tag = 1; _car_In.CI_Frame = null; if (!string.IsNullOrEmpty((string)data.CI_Frame)) { _car_In.CI_Frame = data.CI_Frame; } _car_In.CI_Driving = null; if (!string.IsNullOrEmpty((string)data.CI_Driving)) { _car_In.CI_Driving = data.CI_Driving; } _car_In.CI_Driving_Type = null; if (!string.IsNullOrEmpty((string)data.CI_Driving_Type)) { _car_In.CI_Driving_Type = data.CI_Driving_Type; } _car_In.CI_Driving_dt = null; if (!string.IsNullOrEmpty((string)data.CI_Driving_dt)) { _car_In.CI_Driving_dt = Convert.ToDateTime(data.CI_Driving_dt); } _car_In.CI_Warr_St_dt = null; if (!string.IsNullOrEmpty((string)data.CI_Warr_St_dt)) { _car_In.CI_Warr_St_dt = Convert.ToDateTime(data.CI_Warr_St_dt); } _car_In.CI_remarks = null; _object = _b_myCar.modify_Car(_car_In); }
private void CarBind_Adviser(dynamic data) { CT_Car_Inventory _car_o = new CT_Car_Inventory() { CI_AU_Code = (long)data.AU_Code, CI_Code = (int)data.CI_Code, DE_Code = (int)data.DE_Code, IS_Bind = (bool)data.IS_Bind }; _object = _b_myCar.CarBind_Adviser(_car_o); }
public int Modify_Car(CT_Car_Inventory _c) { #region 参数 SqlParameter[] parameters = { new SqlParameter("@CI_AU_Code", SqlDbType.BigInt), new SqlParameter("@CI_CS_Code", SqlDbType.Int), new SqlParameter("@CI_VIN", SqlDbType.VarChar, 20), new SqlParameter("@CI_Mileage", SqlDbType.Int), new SqlParameter("@CI_Licence", SqlDbType.NVarChar, 15), new SqlParameter("@CI_Licence_dt", SqlDbType.SmallDateTime), new SqlParameter("@CI_YR_Code", SqlDbType.TinyInt), new SqlParameter("@CI_Color_I", SqlDbType.Int), new SqlParameter("@CI_Color_E", SqlDbType.Int), new SqlParameter("@CI_Picture_FN", SqlDbType.NVarChar, 100), new SqlParameter("@CI_Status", SqlDbType.Char, 1), new SqlParameter("@CI_Activate_Tag", SqlDbType.TinyInt), new SqlParameter("@CI_Frame", SqlDbType.NVarChar, 100), new SqlParameter("@CI_Driving", SqlDbType.NVarChar, 100), new SqlParameter("@CI_Driving_Type", SqlDbType.NVarChar, 100), new SqlParameter("@CI_Driving_dt", SqlDbType.SmallDateTime), new SqlParameter("@CI_Warr_St_dt", SqlDbType.SmallDateTime), new SqlParameter("@CI_remarks", SqlDbType.NVarChar, 100) }; parameters[0].Value = _c.CI_AU_Code; parameters[1].Value = _c.CI_CS_Code; parameters[2].Value = _c.CI_VIN; parameters[3].Value = _c.CI_Mileage; parameters[4].Value = _c.CI_Licence; parameters[5].Value = _c.CI_Licence_dt; parameters[6].Value = _c.CI_YR_Code; parameters[7].Value = _c.CI_Color_I; parameters[8].Value = _c.CI_Color_E; parameters[9].Value = _c.CI_Picture_FN; parameters[10].Value = _c.CI_Status; parameters[11].Value = _c.CI_Activate_Tag; parameters[12].Value = _c.CI_Frame; parameters[13].Value = _c.CI_Driving; parameters[14].Value = _c.CI_Driving_Type; parameters[15].Value = _c.CI_Driving_dt; parameters[16].Value = _c.CI_Warr_St_dt; parameters[17].Value = _c.CI_remarks; #endregion return(SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "02_Modify_Car_W", parameters)); }
public int CarBind_Adviser(CT_Car_Inventory o) { #region 参数 SqlParameter[] parameters = { new SqlParameter("@AU_Code", SqlDbType.BigInt), new SqlParameter("@CI_Code", SqlDbType.Int), new SqlParameter("@DE_Code", SqlDbType.Int), new SqlParameter("@IS_Bind", SqlDbType.Bit) }; parameters[0].Value = o.CI_AU_Code; parameters[1].Value = o.CI_Code; parameters[2].Value = o.DE_Code; parameters[3].Value = o.IS_Bind; #endregion int i = SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "[dbo].[03_Handle_CarBind_Adviser]", parameters); return(i); }
/// <summary> /// 车信息和联动列表 /// </summary> /// <param name="id"></param> /// <param name="CI_CS_Code"></param> private void Get_Car_InventoryAndLendon(int id) { dynamic d = new ExpandoObject(); var db = DBCRMTree.GetInstance(); d.CT_Car_Inventory = CT_Car_Inventory.SingleOrDefault(id); d.CT_Car_Style = CT_Car_Style.SingleOrDefault(d.CT_Car_Inventory.CI_CS_Code); //Get_CT_Car_Style(d.CT_Car_Inventory.CM_Code, d.CT_Car_Inventory.CI_YR_Code); d.CT_Car_Inventory.CI_YR_Code = db.ExecuteScalar <Byte>(@"select YR_Code from [CT_Years] where YR_Year = @0", d.CT_Car_Style.CS_Year); d.CT_Car_Inventory.CM_Code = d.CT_Car_Style.CS_CM_Code; // db.ExecuteScalar<int>(@"select cs_cm_code from [CT_Car_Style] where cs_code = @0", d.CT_Car_Inventory.CI_CS_Code); d.CT_Car_Inventory.MK_Code = db.ExecuteScalar <int>(@"select cm_mk_code from [CT_Car_Model] where cm_code = @0", d.CT_Car_Inventory.CM_Code); d.CT_Car_Inventory.CP_Picture_FN = db.ExecuteScalar <string>(@" SELECT [CP_Picture_FN] + ',' FROM [CT_Car_Pictures] WHERE CP_CI_Code =@0 FOR XML PATH('')" , d.CT_Car_Inventory.CI_Code); d.CT_Car_Model = Get_CT_Car_Model(d.CT_Car_Inventory.MK_Code, d.CT_Car_Inventory.CI_YR_Code); d.CT_Car_Style = Get_CT_Car_Style(d.CT_Car_Inventory.CM_Code, d.CT_Car_Inventory.CI_YR_Code); d.CT_Auto_Insurance = CT_Auto_Insurance.FirstOrDefault("where AI_CI_Code = @0 order by AI_Update_dt desc", d.CT_Car_Inventory.CI_Code); // d.CT_Auto_Insurance = CT_Auto_Insurance.SingleOrDefault(@"Select TOP 1 // AI_Code,AI_CI_Code,AI_IC_Code,AI_IA_Code,AI_Policy,AI_Start_dt,AI_End_dt,AI_Update_dt // from CT_Auto_Insurance where AI_CI_Code = @0 order by AI_Update_dt desc", d.CT_Car_Inventory.CI_Code); string sql_carInfo = string.Format(@"SELECT dbo.Get_Connect_Car(CI.CI_Code,1)AS CAR_CN, dbo.Get_Connect_Car(CI.CI_Code,2)AS CAR_EN,MK_Code,CM_Code,CS_Code,CI.* FROM CT_Make MK INNER JOIN CT_Car_Model CM ON CM.CM_MK_Code=MK.MK_Code INNER JOIN CT_Car_Style CS ON CS.CS_CM_Code=CM.CM_Code INNER JOIN CT_Car_Inventory CI ON CI.CI_CS_Code=CS.CS_Code WHERE CI.CI_Code=@0"); d.carInfo = db.Query <dynamic>(sql_carInfo, id); Response.Write(JsonConvert.SerializeObject(d)); }
/// <summary> /// 保存车信息 /// </summary> /// <param name="data"></param> /// <param name="au_code"></param> private void Save_Car(dynamic data) { var db = DBCRMTree.GetInstance(); try { using (var tran = db.GetTransaction()) { var au_code = (long)data.au_code; var s = JsonConvert.SerializeObject(data.o); CT_Car_Inventory c = JsonConvert.DeserializeObject <CT_Car_Inventory>(s); var ci_code = c.CI_Code; c.CI_AU_Code = au_code; c.CI_Create_dt = DateTime.Now; if (c.CI_Code > 0) { c.Update(new string[] { "CI_AU_Code" , "CI_Create_dt" , "CI_CS_Code" , "CI_VIN" , "CI_Mileage" , "CI_Licence" , "CI_YR_Code" , "CI_Color_I" , "CI_Color_E" }); } else { ci_code = (int)c.Insert(); } CT_Auto_Insurance ai = JsonConvert.DeserializeObject <CT_Auto_Insurance>(s); ai.AI_CI_Code = c.CI_Code; if (db.Exists <CT_Auto_Insurance>("AI_CI_Code=@0", c.CI_Code)) { ai.AI_Update_dt = DateTime.Now; string sql = @"UPDATE CT_Auto_Insurance SET AI_IC_Code = @AI_IC_Code ,AI_IA_Code = @AI_IA_Code ,AI_Policy = @AI_Policy ,AI_End_dt = @AI_End_dt ,AI_Update_dt = @AI_Update_dt WHERE AI_CI_Code=@AI_CI_Code"; db.Execute(sql, ai); } else { ai.Insert(); } var path = System.Configuration.ConfigurationManager.AppSettings["PLUploadPath"]; if (string.IsNullOrWhiteSpace(path)) { path = "~/plupload/"; } path = Server.MapPath(path); var path_save = path + "customer/"; var path_temp = path + "customer_temp/"; //添加图片 if (!string.IsNullOrWhiteSpace(c.CP_Picture_FN)) { string[] imgs = c.CP_Picture_FN.Split(','); foreach (var img in imgs) { if (!string.IsNullOrWhiteSpace(img)) { var _CT_Car_Picture = new CT_Car_Picture(); _CT_Car_Picture.CP_CI_Code = ci_code; _CT_Car_Picture.CP_Picture_FN = img; _CT_Car_Picture.CP_Update_dt = DateTime.Now; _CT_Car_Picture.Insert(); if (!Directory.Exists(path_save)) { Directory.CreateDirectory(path_save); } if (File.Exists(path_temp + img)) { File.Move(path_temp + img, path_save + img); } } } } if (!string.IsNullOrWhiteSpace(c.Picture_Removed)) { string[] imgs_removed = c.Picture_Removed.Split(','); foreach (var img in imgs_removed) { CT_Car_Picture.Delete("where [CP_Picture_FN]=@0", img); var imgPath = path_save + img; if (File.Exists(imgPath)) { File.Delete(imgPath); } } } tran.Complete(); Response.Write(JsonConvert.SerializeObject(new { CI_Code = ci_code, isOK = true })); } } catch (Exception ex) { db.AbortTransaction(); Response.Write(JsonConvert.SerializeObject(new { isOK = false, msg = ex.Message })); } }
public int CarBind_Adviser(CT_Car_Inventory o) { return(_Car.CarBind_Adviser(o)); }
/// <summary> /// 新增或是编辑都可以调用 /// </summary> /// <param name="_c"></param> /// <returns></returns> public int modify_Car(CT_Car_Inventory _c) { return(_Car.Modify_Car(_c)); }