/// <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());
}
