/// <summary> /// 删除角色 /// </summary> /// <param name="RoleKey"></param> /// <returns></returns> public string RemoveRole(int RoleKey) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Del"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _RoleKey = new SqlParameter("@RoleId", RoleKey); _RoleKey.Direction = ParameterDirection.Input; sqlparameterlist.Add(_RoleKey); SqlParameter _RoleName = new SqlParameter("@RoleName", (Object)DBNull.Value); _RoleName.Direction = ParameterDirection.Input; sqlparameterlist.Add(_RoleName); SqlParameter _CreatorId = new SqlParameter("@CreatorId", (Object)DBNull.Value); _CreatorId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CreatorId); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_RoleInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
/// <summary> /// 删除技师信息 /// </summary> /// <param name="oUModel"></param> /// <returns></returns> public string RemoveMechanic(int MechanicId) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Del"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _MechanicId = new SqlParameter("@MechanicId", MechanicId); _MechanicId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_MechanicId); SqlParameter _Name = new SqlParameter("@Name", (Object)DBNull.Value); _Name.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Name); SqlParameter _Introduction = new SqlParameter("@Introduction", (Object)DBNull.Value); _Introduction.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Introduction); SqlParameter _Type = new SqlParameter("@Type", (Object)DBNull.Value); _Type.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Type); SqlParameter _Mobile = new SqlParameter("@Mobile", (Object)DBNull.Value); _Mobile.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Mobile); SqlParameter _Address = new SqlParameter("@Address", (Object)DBNull.Value); _Address.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Address); SqlParameter _Email = new SqlParameter("@Email", (Object)DBNull.Value); _Email.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Email); SqlParameter _StoreId = new SqlParameter("@StoreId", (Object)DBNull.Value); _StoreId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_StoreId); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_MechanicInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
public string AddOperLog(int AdminId, string Module, string OpeDes) { string sql = "insert into dbo.OpeLogInfo(AdminId,Module,OpeDes)values(" + AdminId + ",'" + Module + "','" + OpeDes + "')"; int temp = SqlActuator.ExecuteNonQuery(sql, Config.ConnectionString); return(temp.ToString()); }
/// <summary> /// 添加促销信息 /// </summary> /// <param name="oPModel"></param> /// <returns></returns> public string AddPromotionInfo(PromotionModel oPModel) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Add"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _PromotionId = new SqlParameter("@PromotionId", (Object)DBNull.Value); _PromotionId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_PromotionId); SqlParameter _Title = new SqlParameter("@Title", oPModel.Title == null ? (Object)DBNull.Value : oPModel.Title); _Title.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Title); SqlParameter _Content = new SqlParameter("@Content", oPModel.Content == null ? (Object)DBNull.Value : oPModel.Content); _Title.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Content); SqlParameter _Image = new SqlParameter("@Image", oPModel.Image == null ? (Object)DBNull.Value : oPModel.Image); _Image.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Image); SqlParameter _URL = new SqlParameter("@URL", oPModel.URL == null ? (Object)DBNull.Value : oPModel.URL); _URL.Direction = ParameterDirection.Input; sqlparameterlist.Add(_URL); SqlParameter _CreatorId = new SqlParameter("@CreatorId", oPModel.CreatorId); _CreatorId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CreatorId); SqlParameter _DealerId = new SqlParameter("@DealerId", oPModel.CreatorId); _DealerId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_DealerId); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_PromotionInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
/// <summary> /// 删除新闻 /// </summary> /// <param name="oAModel"></param> /// <returns></returns> public string RemoveNewsInfo(int NewsId) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Del"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _NewsId = new SqlParameter("@NewsId", NewsId); _NewsId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_NewsId); SqlParameter _Title = new SqlParameter("@Title", (Object)DBNull.Value); _Title.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Title); SqlParameter _Image = new SqlParameter("@Image", (Object)DBNull.Value); _Image.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Image); SqlParameter _URL = new SqlParameter("@URL", (Object)DBNull.Value); _URL.Direction = ParameterDirection.Input; sqlparameterlist.Add(_URL); SqlParameter _Content = new SqlParameter("@Content", (Object)DBNull.Value); _Content.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Content); SqlParameter _CreatorId = new SqlParameter("@CreatorId", (Object)DBNull.Value); _CreatorId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CreatorId); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_NewsInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
/// <summary> /// 更新用户密码 /// </summary> /// <param name="oAModel"></param> /// <param name="NewsPassword"></param> /// <returns></returns> public string SetAdminPassword(AdminModel oAModel, string NewsPassword) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Up"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _AdminName = new SqlParameter("@AdminName", oAModel.AdminName == null ? (Object)DBNull.Value : oAModel.AdminName); _AdminName.Direction = ParameterDirection.Input; sqlparameterlist.Add(_AdminName); SqlParameter _AdminPassword = new SqlParameter("@AdminPassword", oAModel.AdminPassword == null ? (Object)DBNull.Value : oAModel.AdminPassword); _AdminPassword.Direction = ParameterDirection.Input; sqlparameterlist.Add(_AdminPassword); SqlParameter _News_AdminPassword = new SqlParameter("@News_AdminPassword", NewsPassword == null ? (Object)DBNull.Value : MD5.SetMD5(NewsPassword)); _News_AdminPassword.Direction = ParameterDirection.Input; sqlparameterlist.Add(_News_AdminPassword); SqlParameter _Type = new SqlParameter("@Type", (Object)DBNull.Value); _Type.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Type); SqlParameter _RoleId = new SqlParameter("@RoleId", oAModel.RoleId); _RoleId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_RoleId); SqlParameter _CreatorId = new SqlParameter("@CreatorId", oAModel.CreatorId); _CreatorId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CreatorId); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_AdminInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
/// <summary> /// 删除用户 /// </summary> /// <param name="oAModel"></param> /// <param name="NewsPassword"></param> /// <returns></returns> public string RemoveAdmin(int AdminId, int status) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Del"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _AdminName = new SqlParameter("@AdminName", (Object)DBNull.Value); _AdminName.Direction = ParameterDirection.Input; sqlparameterlist.Add(_AdminName); SqlParameter _AdminPassword = new SqlParameter("@AdminPassword", (Object)DBNull.Value); _AdminPassword.Direction = ParameterDirection.Input; sqlparameterlist.Add(_AdminPassword); SqlParameter _News_AdminPassword = new SqlParameter("@News_AdminPassword", (Object)DBNull.Value); _News_AdminPassword.Direction = ParameterDirection.Input; sqlparameterlist.Add(_News_AdminPassword); SqlParameter _Type = new SqlParameter("@Type", status); _Type.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Type); SqlParameter _RoleId = new SqlParameter("@RoleId", AdminId); _RoleId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_RoleId); SqlParameter _CreatorId = new SqlParameter("@CreatorId", (Object)DBNull.Value); _CreatorId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CreatorId); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_AdminInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
/// <summary> /// 发所有经销商 /// </summary> /// <param name="oMModel"></param> /// <returns></returns> public string AddAllDealerMessageInfo(MessageModel oMModel) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "AddDealer"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _Messageid = new SqlParameter("@Messageid", (Object)DBNull.Value); _Messageid.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Messageid); SqlParameter _Title = new SqlParameter("@Title", oMModel.Title == null ? (Object)DBNull.Value : oMModel.Title); _Title.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Title); SqlParameter _Content = new SqlParameter("@Content", oMModel.Content == null ? (Object)DBNull.Value : oMModel.Content); _Content.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Content); SqlParameter _isRead = new SqlParameter("@isRead", (Object)DBNull.Value); _isRead.Direction = ParameterDirection.Input; sqlparameterlist.Add(_isRead); SqlParameter _From = new SqlParameter("@From", oMModel.From); _From.Direction = ParameterDirection.Input; sqlparameterlist.Add(_From); SqlParameter _To = new SqlParameter("@To", oMModel.To); _To.Direction = ParameterDirection.Input; sqlparameterlist.Add(_To); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_MessageInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
/// <summary> /// 删除消息信息 /// </summary> /// <param name="MessageId"></param> /// <returns></returns> public string RemoveMessageInfoTo(int MessageId, int To) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "DelTo"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _Messageid = new SqlParameter("@Messageid", MessageId); _Messageid.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Messageid); SqlParameter _Title = new SqlParameter("@Title", (Object)DBNull.Value); _Title.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Title); SqlParameter _Content = new SqlParameter("@Content", (Object)DBNull.Value); _Content.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Content); SqlParameter _isRead = new SqlParameter("@isRead", (Object)DBNull.Value); _isRead.Direction = ParameterDirection.Input; sqlparameterlist.Add(_isRead); SqlParameter _From = new SqlParameter("@From", (Object)DBNull.Value); _From.Direction = ParameterDirection.Input; sqlparameterlist.Add(_From); SqlParameter _To = new SqlParameter("@To", To); _To.Direction = ParameterDirection.Input; sqlparameterlist.Add(_To); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_MessageInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
/// <summary> /// 删除评论 /// </summary> /// <param name="oPModel"></param> /// <returns></returns> public string RemoveCommentInfo(int CommentId) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Del"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _CommentId = new SqlParameter("@CommentId", CommentId); _CommentId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CommentId); SqlParameter _CompensateNo = new SqlParameter("@CompensateNo", (Object)DBNull.Value); _CompensateNo.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CompensateNo); SqlParameter _Content = new SqlParameter("@Content", (Object)DBNull.Value); _Content.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Content); SqlParameter _CreatorId = new SqlParameter("@CreatorId", (Object)DBNull.Value); _CreatorId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CreatorId); SqlParameter _Parents_CommentId = new SqlParameter("@Parents_CommentId", (Object)DBNull.Value); _Parents_CommentId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Parents_CommentId); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_CommentInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
/// <summary> /// 添加权限 /// </summary> /// <param name="RoleKey"></param> /// <param name="ModuleKey"></param> /// <param name="PermissionKey"></param> /// <returns></returns> public string AddPermissionRelation(int RoleId, string ModuleKey, int PermissionId, int CreatorId) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Add"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _RoleId = new SqlParameter("@RoleId", RoleId); _RoleId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_RoleId); SqlParameter _ModuleKey = new SqlParameter("@ModuleKey", ModuleKey); _ModuleKey.Direction = ParameterDirection.Input; sqlparameterlist.Add(_ModuleKey); SqlParameter _PermissionsId = new SqlParameter("@PermissionsId", PermissionId); _PermissionsId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_PermissionsId); SqlParameter _CreatorId = new SqlParameter("@CreatorId", CreatorId); _CreatorId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CreatorId); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_Permissions", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
/// <summary> /// 更新厂家类别 /// </summary> /// <param name="ProductSecondLeveName"></param> /// <param name="ProductFirstLevelId"></param> /// <returns></returns> public string SetFactoryTypeInfo(string FactoryTypeName, string ProductSecondLevelNameDefalut, int FactoryTypeId) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Up"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _FactoryTypeId = new SqlParameter("@FactoryTypeId", FactoryTypeId); _FactoryTypeId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_FactoryTypeId); SqlParameter _FactoryTypeName = new SqlParameter("@FactoryTypeName", FactoryTypeName); _FactoryTypeName.Direction = ParameterDirection.Input; sqlparameterlist.Add(_FactoryTypeName); SqlParameter _ProductSecondLevelNameDefalute = new SqlParameter("@ProductSecondLevelNameDefalut", ProductSecondLevelNameDefalut); _ProductSecondLevelNameDefalute.Direction = ParameterDirection.Input; sqlparameterlist.Add(_ProductSecondLevelNameDefalute); SqlParameter _CreatorId = new SqlParameter("@CreatorId", (Object)DBNull.Value); _CreatorId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CreatorId); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_FactoryTypeInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
public string GetLoginInfo(string Ip) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Get"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _Ip = new SqlParameter("@Ip", Ip); _Ip.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Ip); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_LoginInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
/// <summary> /// 添加反馈信息 /// </summary> /// <param name="oFBModel"></param> /// <returns></returns> public string AddFeedBackInfo(FeedBackModel oFBModel) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Add"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _FeedBackId = new SqlParameter("@FeedBackId", (Object)DBNull.Value); _FeedBackId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_FeedBackId); SqlParameter _Title = new SqlParameter("@Title", oFBModel.Title == null ? (Object)DBNull.Value : oFBModel.Title); _Title.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Title); SqlParameter _Content = new SqlParameter("@Content", oFBModel.Content == null ? (Object)DBNull.Value : oFBModel.Content); _Content.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Content); SqlParameter _Name = new SqlParameter("@Name", oFBModel.Name == null ? (Object)DBNull.Value : oFBModel.Name); _Name.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Name); SqlParameter _Mobile = new SqlParameter("@Mobile", oFBModel.Mobile == null ? (Object)DBNull.Value : oFBModel.Mobile); _Mobile.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Mobile); SqlParameter _Email = new SqlParameter("@Email", oFBModel.Email == null ? (Object)DBNull.Value : oFBModel.Email); _Email.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Email); SqlParameter _ProvinceId = new SqlParameter("@ProvinceId", oFBModel.ProvinceId); _ProvinceId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_ProvinceId); SqlParameter _CityId = new SqlParameter("@CityId", oFBModel.CityId); _CityId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CityId); SqlParameter _Address = new SqlParameter("@Address", oFBModel.Address == null ? (Object)DBNull.Value : oFBModel.Address); _Address.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Address); SqlParameter _Zip = new SqlParameter("@Zip", oFBModel.Zip == null ? (Object)DBNull.Value : oFBModel.Zip); _Zip.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Zip); SqlParameter _CreatorId = new SqlParameter("@CreatorId", oFBModel.CreatorId); _CreatorId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CreatorId); SqlParameter _IsdisplayDealer = new SqlParameter("@IsdisplayDealer", oFBModel.IsdisplayDealer); _IsdisplayDealer.Direction = ParameterDirection.Input; sqlparameterlist.Add(_IsdisplayDealer); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_FeedBackInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
/// 删除用户 /// </summary> /// <param name="oUModel"></param> /// <returns></returns> public string RemoveUser(int UserId) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Del"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _UserId = new SqlParameter("@UserId", UserId); _UserId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_UserId); SqlParameter _UserName = new SqlParameter("@UserName", (Object)DBNull.Value); _UserName.Direction = ParameterDirection.Input; sqlparameterlist.Add(_UserName); SqlParameter _CarBrandCode = new SqlParameter("@CarBrandCode", (Object)DBNull.Value); _CarBrandCode.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CarBrandCode); SqlParameter _CarSystemCode = new SqlParameter("@CarSystemCode", (Object)DBNull.Value); _CarSystemCode.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CarSystemCode); SqlParameter _CarTypeCode = new SqlParameter("@CarTypeCode", (Object)DBNull.Value); _CarTypeCode.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CarTypeCode); SqlParameter _Licence = new SqlParameter("@Licence", (Object)DBNull.Value); _Licence.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Licence); SqlParameter _ProvinceId = new SqlParameter("@ProvinceId", (Object)DBNull.Value); _ProvinceId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_ProvinceId); SqlParameter _CityId = new SqlParameter("@CityId", (Object)DBNull.Value); _CityId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CityId); SqlParameter _Price = new SqlParameter("@Price", (Object)DBNull.Value); _Price.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Price); SqlParameter _Mobile = new SqlParameter("@Mobile", (Object)DBNull.Value); _Mobile.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Mobile); SqlParameter _Email = new SqlParameter("@Email", (Object)DBNull.Value); _Email.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Email); SqlParameter _StoreId = new SqlParameter("@StoreId", (Object)DBNull.Value); _StoreId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_StoreId); SqlParameter _ProductCode = new SqlParameter("@ProductCode", (Object)DBNull.Value); _ProductCode.Direction = ParameterDirection.Input; sqlparameterlist.Add(_ProductCode); SqlParameter _F_ProductTypeId = new SqlParameter("@ProductFirstLevelId", (Object)DBNull.Value); _F_ProductTypeId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_F_ProductTypeId); SqlParameter _S_ProductTypeId = new SqlParameter("@ProductSecondLevelId", (Object)DBNull.Value); _S_ProductTypeId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_S_ProductTypeId); SqlParameter _ImageList = new SqlParameter("@ImageList", (Object)DBNull.Value); _ImageList.Direction = ParameterDirection.Input; sqlparameterlist.Add(_ImageList); SqlParameter _MechanicId = new SqlParameter("@MechanicId", (Object)DBNull.Value); _MechanicId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_MechanicId); SqlParameter _IsQuanCare = new SqlParameter("@IsQuanCare", (Object)DBNull.Value); _IsQuanCare.Direction = ParameterDirection.Input; sqlparameterlist.Add(_IsQuanCare); SqlParameter _Remark = new SqlParameter("@Remark", (Object)DBNull.Value); _Remark.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Remark); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_UserInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
/// <summary> /// 添加加盟店数据 /// </summary> /// <param name="oAModel"></param> /// <returns></returns> public string AddStoreInfo(StoreModel oAModel) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Add"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _AdminId = new SqlParameter("@AdminId", oAModel.AdminId); _AdminId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_AdminId); SqlParameter _StoreName = new SqlParameter("@StoreName", oAModel.StoreName == null ? (Object)DBNull.Value : oAModel.StoreName); _StoreName.Direction = ParameterDirection.Input; sqlparameterlist.Add(_StoreName); SqlParameter _Contacts = new SqlParameter("@Contacts", oAModel.Contacts == null ? (Object)DBNull.Value : oAModel.Contacts); _Contacts.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Contacts); SqlParameter _Position = new SqlParameter("@Position", oAModel.Position == null ? (Object)DBNull.Value : oAModel.Position); _Position.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Position); SqlParameter _Phone = new SqlParameter("@Phone", oAModel.Phone == null ? (Object)DBNull.Value : oAModel.Phone); _Phone.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Phone); SqlParameter _Mobile = new SqlParameter("@Mobile", oAModel.Mobile == null ? (Object)DBNull.Value : oAModel.Mobile); _Mobile.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Mobile); SqlParameter _Fax = new SqlParameter("@Fax", oAModel.Fax == null ? (Object)DBNull.Value : oAModel.Fax); _Fax.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Fax); SqlParameter _ProvinceId = new SqlParameter("@ProvinceId", oAModel.ProvinceId); _ProvinceId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_ProvinceId); SqlParameter _CityId = new SqlParameter("@CityId", oAModel.CityId); _CityId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CityId); SqlParameter _Address = new SqlParameter("@Address", oAModel.Address == null ? (Object)DBNull.Value : oAModel.Address); _Address.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Address); SqlParameter _Zip = new SqlParameter("@Zip", oAModel.Zip == null ? (Object)DBNull.Value : oAModel.Zip); _Zip.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Zip); SqlParameter _Email = new SqlParameter("@Email", oAModel.Email == null ? (Object)DBNull.Value : oAModel.Email); _Email.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Email); SqlParameter _URL = new SqlParameter("@URL", oAModel.URL == null ? (Object)DBNull.Value : oAModel.URL); _URL.Direction = ParameterDirection.Input; sqlparameterlist.Add(_URL); SqlParameter _StoreDes = new SqlParameter("@StoreDes", oAModel.StoreDes == null ? (Object)DBNull.Value : oAModel.StoreDes); _StoreDes.Direction = ParameterDirection.Input; sqlparameterlist.Add(_StoreDes); SqlParameter _Remark = new SqlParameter("@Remark", oAModel.Remark == null ? (Object)DBNull.Value : oAModel.Remark); _Remark.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Remark); SqlParameter _DealerId = new SqlParameter("@DealerId", oAModel.DealerId); _DealerId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_DealerId); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_StoreInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
/// <summary> /// 删除经销商数据 /// </summary> /// <param name="oAModel"></param> /// <returns></returns> public string RemoveDealerInfo(int AdminId) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Del"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _AdminId = new SqlParameter("@AdminId", AdminId); _AdminId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_AdminId); SqlParameter _DealerCompanyName = new SqlParameter("@DealerCompanyName", (Object)DBNull.Value); _DealerCompanyName.Direction = ParameterDirection.Input; sqlparameterlist.Add(_DealerCompanyName); SqlParameter _Contacts = new SqlParameter("@Contacts", (Object)DBNull.Value); _Contacts.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Contacts); SqlParameter _Position = new SqlParameter("@Position", (Object)DBNull.Value); _Position.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Position); SqlParameter _Phone = new SqlParameter("@Phone", (Object)DBNull.Value); _Phone.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Phone); SqlParameter _Mobile = new SqlParameter("@Mobile", (Object)DBNull.Value); _Mobile.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Mobile); SqlParameter _Fax = new SqlParameter("@Fax", (Object)DBNull.Value); _Fax.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Fax); SqlParameter _ProvinceId = new SqlParameter("@ProvinceId", (Object)DBNull.Value); _ProvinceId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_ProvinceId); SqlParameter _CityId = new SqlParameter("@CityId", (Object)DBNull.Value); _CityId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CityId); SqlParameter _Address = new SqlParameter("@Address", (Object)DBNull.Value); _Address.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Address); SqlParameter _Zip = new SqlParameter("@Zip", (Object)DBNull.Value); _Zip.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Zip); SqlParameter _Email = new SqlParameter("@Email", (Object)DBNull.Value); _Email.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Email); SqlParameter _URL = new SqlParameter("@URL", (Object)DBNull.Value); _URL.Direction = ParameterDirection.Input; sqlparameterlist.Add(_URL); SqlParameter _DealerAreaLevelDes = new SqlParameter("@DealerAreaLevelDes", (Object)DBNull.Value); _DealerAreaLevelDes.Direction = ParameterDirection.Input; sqlparameterlist.Add(_DealerAreaLevelDes); SqlParameter _Remark = new SqlParameter("@Remark", (Object)DBNull.Value); _Remark.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Remark); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_DealerInfo", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }
public string Add_T_User(UserModel oUModel) { List <SqlParameter> sqlparameterlist = new List <SqlParameter>(); SqlParameter _op = new SqlParameter("@op", "Add"); _op.Direction = ParameterDirection.Input; sqlparameterlist.Add(_op); SqlParameter _UserId = new SqlParameter("@UserId", (Object)DBNull.Value); _UserId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_UserId); SqlParameter _UserName = new SqlParameter("@UserName", oUModel.UserName == null ? (Object)DBNull.Value : oUModel.UserName); _UserName.Direction = ParameterDirection.Input; sqlparameterlist.Add(_UserName); SqlParameter _CarBrandCode = new SqlParameter("@CarBrandCode", oUModel.CarBrandCode); _CarBrandCode.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CarBrandCode); SqlParameter _CarSystemCode = new SqlParameter("@CarSystemCode", oUModel.CarSystemCode); _CarSystemCode.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CarSystemCode); SqlParameter _CarTypeCode = new SqlParameter("@CarTypeCode", oUModel.CarTypeCode); _CarTypeCode.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CarTypeCode); SqlParameter _Licence = new SqlParameter("@Licence", oUModel.Lincence == null ? (Object)DBNull.Value : oUModel.Lincence); _Licence.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Licence); SqlParameter _ProvinceId = new SqlParameter("@ProvinceId", oUModel.ProvinceId); _ProvinceId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_ProvinceId); SqlParameter _CityId = new SqlParameter("@CityId", oUModel.CityId); _CityId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_CityId); SqlParameter _Price = new SqlParameter("@Price", oUModel.Price); _Price.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Price); SqlParameter _Mobile = new SqlParameter("@Mobile", oUModel.Mobile == null ? (Object)DBNull.Value : oUModel.Mobile); _Mobile.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Mobile); SqlParameter _Email = new SqlParameter("@Email", oUModel.Email == null ? (Object)DBNull.Value : oUModel.Email); _Email.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Email); SqlParameter _StoreId = new SqlParameter("@StoreId", oUModel.StoreId); _StoreId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_StoreId); SqlParameter _ProductCode = new SqlParameter("@ProductCode", oUModel.ProductCode == null ? (Object)DBNull.Value : oUModel.ProductCode); _ProductCode.Direction = ParameterDirection.Input; sqlparameterlist.Add(_ProductCode); SqlParameter _F_ProductTypeId = new SqlParameter("@ProductFirstLevelId", oUModel.F_ProductTypeId); _F_ProductTypeId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_F_ProductTypeId); SqlParameter _S_ProductTypeId = new SqlParameter("@ProductSecondLevelId", oUModel.S_ProductTypeId); _S_ProductTypeId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_S_ProductTypeId); SqlParameter _ImageList = new SqlParameter("@ImageList", oUModel.ImageList); _ImageList.Direction = ParameterDirection.Input; sqlparameterlist.Add(_ImageList); SqlParameter _MechanicId = new SqlParameter("@MechanicId", oUModel.MechanicId); _MechanicId.Direction = ParameterDirection.Input; sqlparameterlist.Add(_MechanicId); SqlParameter _Type = new SqlParameter("@Type", oUModel.Type); _Type.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Type); SqlParameter _Meter = new SqlParameter("@Meter", oUModel.Meter); _Meter.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Meter); SqlParameter _Address = new SqlParameter("@Address", oUModel.Address); _Address.Direction = ParameterDirection.Input; sqlparameterlist.Add(_Address); SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10); _result.Direction = ParameterDirection.Output; sqlparameterlist.Add(_result); SqlActuator.ExecuteNonQuery("sp_User_T_Info", sqlparameterlist, Config.ConnectionString); return(_result.Value.ToString()); }