public int UpdateAdmin(NewModel newModel)
{
string updateFild = string.Empty;
//SqlParameter集合,把所有要更新的字段,用SqlParameter封装起来，放进集合
List <SqlParameter> sqlParameters = new List <SqlParameter>();
if (newModel.UserName != string.Empty)
{
updateFild += "UserName=@UserName ,";
//封装SqlParameter的最简单的方法
SqlParameter Parameter = new SqlParameter("@UserName", SqlDbType.Text);
Parameter.Value = newModel.UserName;
//添加进我们的集合
sqlParameters.Add(Parameter);
}
if (newModel.PassWord != string.Empty)
{
updateFild += "PassWord=@PassWord ,";
SqlParameter Parameter = new SqlParameter("@PassWord", SqlDbType.Text);
Parameter.Value = newModel.PassWord;
sqlParameters.Add(Parameter);
}
updateFild = updateFild.TrimEnd(',');
string sql = $"update AdminUser set {updateFild} where id={newModel.ID}";
return(SqlHelper.ExNon(sql, sqlParameters.ToArray()));
}
public int InsertMess(NewModel newModel)
{
string sql = "insert into Message (name,content,tel) values(@name,@content,@tel)";
SqlParameter[] sqlParameters =
{
new SqlParameter("name", SqlDbType.NVarChar),
new SqlParameter("content", SqlDbType.Text),
new SqlParameter("tel", SqlDbType.NVarChar)
};
sqlParameters[0].Value = newModel.Name;
sqlParameters[1].Value = newModel.MContent;
sqlParameters[2].Value = newModel.Tel;
return(SqlHelper.ExNon(sql, sqlParameters));
}
public int AddAdmin(NewModel newModel)
{
string sql = "insert into AdminUser (UserName,PassWord,Level) values(@UserName,@PassWord,@Level)";
SqlParameter[] sqlParameters =
{
new SqlParameter("UserName", SqlDbType.Text),
new SqlParameter("PassWord", SqlDbType.Text),
new SqlParameter("Level", SqlDbType.Text)
};
sqlParameters[0].Value = newModel.UserName;
sqlParameters[1].Value = newModel.PassWord;
sqlParameters[2].Value = newModel.Level;
return(SqlHelper.ExNon(sql, sqlParameters));
}
public int UpdateNew(NewModel newModel)
{
string updateFild = string.Empty;
//SqlParameter集合,把所有要更新的字段,用SqlParameter封装起来，放进集合
List <SqlParameter> sqlParameters = new List <SqlParameter>();
if (newModel.Title != string.Empty)
{
updateFild += "title=@title ,";
//封装SqlParameter的最简单的方法
SqlParameter Parameter = new SqlParameter("@title", SqlDbType.NVarChar);
Parameter.Value = newModel.Title;
//添加进我们的集合
sqlParameters.Add(Parameter);
}
if (newModel.Content != string.Empty)
{
updateFild += "content=@content ,";
SqlParameter Parameter = new SqlParameter("@content", SqlDbType.Text);
Parameter.Value = newModel.Content;
sqlParameters.Add(Parameter);
}
if (newModel.DateTime != string.Empty)
{
updateFild += "datetime=@datetime ,";
SqlParameter Parameter = new SqlParameter("@datetime", SqlDbType.DateTime);
Parameter.Value = newModel.DateTime;
sqlParameters.Add(Parameter);
}
if (newModel.Type != string.Empty)
{
updateFild += "type=@type ,";
SqlParameter Parameter = new SqlParameter("@type", SqlDbType.Int);
Parameter.Value = newModel.Type;
sqlParameters.Add(Parameter);
}
//删掉尾部的逗号
updateFild = updateFild.TrimEnd(',');
string sql = $"update NewList set {updateFild} where id={newModel.Id}";
return(SqlHelper.ExNon(sql, sqlParameters.ToArray()));
}
public int InsertNew(NewModel newModel)
{
string sql = "insert into NewList (title,content,type,images) values(@title,@content,@type,@images)";
SqlParameter[] sqlParameters =
{
new SqlParameter("title", SqlDbType.NVarChar),
new SqlParameter("content", SqlDbType.Text),
new SqlParameter("type", SqlDbType.Int),
//new SqlParameter("datetime",SqlDbType.DateTime),
new SqlParameter("images", SqlDbType.NVarChar)
};
sqlParameters[0].Value = newModel.Title;
sqlParameters[1].Value = newModel.Content;
sqlParameters[2].Value = newModel.Type;
//sqlParameters[3].Value = newModel.DateTime;
sqlParameters[3].Value = newModel.Images;
return(SqlHelper.ExNon(sql, sqlParameters));
}
public int InsertProduct(NewModel newModel)
{
string sql = "insert into Product (name,content,type,image) values(@name,@content,@type,@image)";
SqlParameter[] sqlParameters =
{
new SqlParameter("name", SqlDbType.NVarChar),
new SqlParameter("content", SqlDbType.Text),
new SqlParameter("type", SqlDbType.Int),
//new SqlParameter("datetime",SqlDbType.DateTime),
new SqlParameter("image", SqlDbType.NVarChar)
};
sqlParameters[0].Value = newModel.ProName;
sqlParameters[1].Value = newModel.ProContent;
sqlParameters[2].Value = newModel.ProType;
//sqlParameters[3].Value = newModel.DateTime;
sqlParameters[3].Value = newModel.ProImage;
return(SqlHelper.ExNon(sql, sqlParameters));
}
