/// <summary> /// 添加客户资源 /// </summary> /// <param name="model">The model.</param> /// <returns>System.Int32.</returns> public static int InsertCustomerRes(CustomerResModel model) { using (var dal = FactoryDispatcher.CustomerFactory()) { return(dal.InsertCustomerRes(model)); } }
/// <summary> /// 添加客户资源 /// </summary> /// <param name="model">The model.</param> /// <returns>System.Int32.</returns> public int InsertCustomerRes(CustomerResModel model) { string strSql = "insert into BM_CustomerRes (UserId,Name,Mobile,Addr,Remark,DataImg,SubmitName,Type) values(@UserId,@Name,@Mobile,@Addr,@Remark,@DataImg,@SubmitName,@Type);select @@IDENTITY;"; var param = new[] { new SqlParameter("@UserId", model.UserId), new SqlParameter("@Name", model.Name), new SqlParameter("@Mobile", model.Mobile), new SqlParameter("@Addr", model.Addr), new SqlParameter("@Remark", model.Remark), new SqlParameter("@DataImg", model.DataImg), new SqlParameter("@SubmitName", model.SubmitName), new SqlParameter("@Type", model.Type) }; object obj = DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param); if (obj != null) { return(Convert.ToInt32(obj)); } return(0); }