//public CompanysInfo GetModel(string where)
//{
// try
// {
// StringBuilder strSql = new StringBuilder();
// strSql.Append("select * ");
// strSql.Append(" from Companys ");
// if (where.Trim().Length>0)
// strSql.Append(" where " + where);
// CompanysInfo info = new CompanysInfo();
// using (SqlDataReader dr = SqlDbHelper.ExecuteReader(Config.SqlConnection,strSql.ToString(), CommandType.Text))
// {
// if (dr.Read())
// {
// info = GetInfoByDr(dr);
// }
// }
// return info;
// }
// catch { }
// return null;
//}
public int Getid(string domain, string where)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CompanyID ");
strSql.Append(" from Companys ");
strSql.Append(" where domain=@domain ");
if (where.Trim().Length > 0)
{
strSql.Append(" and " + where);
}
SqlParameter[] parameters =
{
new SqlParameter("@domain", SqlDbType.VarChar, 80)
};
parameters[0].Value = domain;
CompanysInfo info = new CompanysInfo();
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters);
return(obj != null && obj != DBNull.Value ? Convert.ToInt32(obj) : 0);
}
catch { }
return(0);
}
public int getmaxid()
{
string sql = "select max(CompanyID) from Companys";
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, sql, CommandType.Text);
int id = obj != null && obj != DBNull.Value ? Convert.ToInt32(obj) : 0;
return(id);
}
public int getcount(string where)
{
string sql = "select count(1) from goodsExch";
if (where.Trim().Length > 0)
{
sql = sql + " where " + where;
}
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, sql);
return(obj != null && obj != DBNull.Value ? Convert.ToInt32(obj) : 0);
}
public int Add(article_categoryInfo model, ref string resultMsg)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into article_category(");
strSql.Append("img,content,seo_title,seo_keywords,seo_description,channel_id,title,call_index,parentid,orderby,link_url,companyid");
strSql.Append(") values (");
strSql.Append("@img,@content,@seo_title,@seo_keywords,@seo_description,@channel_id,@title,@call_index,@parentid,@orderby,@link_url,@companyid");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@img", SqlDbType.NVarChar, 255),
new SqlParameter("@content", SqlDbType.Text),
new SqlParameter("@seo_title", SqlDbType.NVarChar, 255),
new SqlParameter("@seo_keywords", SqlDbType.NVarChar, 255),
new SqlParameter("@seo_description", SqlDbType.NVarChar, 255),
new SqlParameter("@channel_id", SqlDbType.Int, 4),
new SqlParameter("@title", SqlDbType.NVarChar, 100),
new SqlParameter("@call_index", SqlDbType.NVarChar, 50),
new SqlParameter("@parentid", SqlDbType.Int, 4),
new SqlParameter("@orderby", SqlDbType.Int, 4),
new SqlParameter("@link_url", SqlDbType.NVarChar, 255),
new SqlParameter("@companyid", SqlDbType.Int, 4),
};
parameters[0].Value = model.img;
parameters[1].Value = model.content;
parameters[2].Value = model.seo_title;
parameters[3].Value = model.seo_keywords;
parameters[4].Value = model.seo_description;
parameters[5].Value = model.channel_id;
parameters[6].Value = model.title;
parameters[7].Value = model.call_index;
parameters[8].Value = model.parentid;
parameters[9].Value = model.orderby;
parameters[10].Value = model.link_url;
parameters[11].Value = model.companyid;
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
catch (Exception exc)
{ resultMsg = exc.Message; }
return(0);
}
public string get_parentids(int DistId)
{
string sql = "select parentids from District where DistId=@DistId";
SqlParameter[] parameters =
{
new SqlParameter("@DistId", SqlDbType.Int)
};
parameters[0].Value = DistId;
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, sql, CommandType.Text, parameters);
return(obj != null && obj != DBNull.Value ? obj.ToString() : "");
}
public int get_parentid(int goods_category_id)
{
string sql = "select parentid from goods_category where goods_category_id=@goods_category_id";
SqlParameter[] parameters =
{
new SqlParameter("@goods_category_id", SqlDbType.Int)
};
parameters[0].Value = goods_category_id;
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, sql, CommandType.Text, parameters);
return(obj != null && obj != DBNull.Value ? Convert.ToInt32(obj) : 0);
}
/// <summary>
///
/// </summary>
/// <param name="TableName"></param>
/// <param name="where"></param>
/// <returns></returns>
public int GetCount(string TableName, string where)
{
try
{
string sql = "select count(1) from " + TableName;
if (where.Trim().Length > 0)
{
sql = sql + " where " + where;
}
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, sql, CommandType.Text);
return(obj != null && obj != DBNull.Value ? Convert.ToInt32(obj) : 0);
}
catch { }
return(-1);
}
public void selectteam(string teacherID, string teamID)
{
string ssql = "select count(1) from teacherselect where teacherno=@teacheruid and teamno=@teamuid"; //查询是否有重复选择
string sql = "insert into teacherselect(teacherno,teamno) values(@teacheruid,@teamuid)"; //将选择的队伍放入教师选择表中
SqlParameter p1 = new SqlParameter("teacheruid", teacherID);
SqlParameter p2 = new SqlParameter("teamuid", teamID);
SqlParameter[] sps = { p1, p2 };
int i = Convert.ToInt32(SqlDbHelper.ExecuteScalar(ssql, CommandType.Text, sps));
if (i != 1)
{
SqlDbHelper.ExecuteNonQuery(sql, CommandType.Text, sps);
}
}
public int Getidbywhere(string where)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select uid ");
strSql.Append(" from member ");
if (where.Trim().Length > 0)
{
strSql.Append(" where " + where);
}
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, strSql.ToString(), CommandType.Text);
return(obj != null && obj != DBNull.Value ? Convert.ToInt32(obj) : 0);
}
catch { }
return(0);
}
/// <summary>
/// 检查该教师信息是否已存在数据库
/// </summary>
/// <param name="teacherNo"></param>
/// <returns></returns>
public bool CheckExist(string teacherNo)
{
string strSql = "select * from [teacher] where teacherno=@teacherno";
SqlParameter[] parameters =
{
new SqlParameter("@teacherno", SqlDbType.VarChar, 50),
};
parameters[0].Value = teacherNo;
if (SqlDbHelper.ExecuteScalar(strSql, CommandType.Text, parameters) != null)
{
return(true);
}
else
{
return(false);
}
}
public int GetCityIDByCityName(string CityName)
{
try
{
string sql = "select CityID from City WHERE [City] like '%" + CityName + "%'";
//SqlParameter[] paras = new SqlParameter[]{
// new SqlParameter("@ProvinceName",SqlDbType),
//};
//paras[0].Value = ProvinceName;
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, sql, CommandType.Text, null);
return(Convert.ToInt32(obj));
// return excrows;
}
catch
{ }
return(0);
}
public string GetCompanyId(int userid)
{
try
{
//string sql = "select CompanyID from Companys where userid=@userid";
//SqlParameter[] parameters = {
// new SqlParameter("@userid", SqlDbType.Int,4),
//};
//parameters[0].Value = userid;
//object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, sql, CommandType.Text, parameters);
//string companyid = obj != null && obj != DBNull.Value ? obj.ToString() : "";
//if (companyid.Trim().Length > 0)
// return companyid;
//SqlParameter[] parameters2 = {
// new SqlParameter("@userid", SqlDbType.Int,4),
//};
//parameters2[0].Value = userid;
//string sql2 = "select CompanyID from Persons where userid=@userid";
//object obj2 = SqlDbHelper.ExecuteScalar(Config.SqlConnection, sql2, CommandType.Text, parameters2);
//companyid = obj2 != null && obj2 != DBNull.Value ? obj2.ToString() : "";
//return companyid;
string sql = "select CompanyId from Users where userid=@userid";
SqlParameter[] parameters =
{
new SqlParameter("@userid", SqlDbType.Int, 4),
};
parameters[0].Value = userid;
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, sql, CommandType.Text, parameters);
string companyid = obj != null && obj != DBNull.Value ? obj.ToString() : "";
if (companyid.Trim().Length > 0)
{
return(companyid);
}
}
catch
{ }
return("");
}
/// <summary>
/// 查余额
/// </summary>
/// <param name="CompanyID"></param>
/// <returns></returns>
public decimal Gettotalamount(int CompanyID)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select totalamount ");
strSql.Append(" from Companys ");
strSql.Append(" where CompanyID=@CompanyID");
SqlParameter[] parameters =
{
new SqlParameter("@CompanyID", SqlDbType.Int, 4)
};
parameters[0].Value = CompanyID;
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters);
return(obj != DBNull.Value && obj != null?Convert.ToDecimal(obj) : 0);
}
catch { }
return(-1);
}
/// <summary>
/// 查会员余额
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public decimal Getbalance(long uid)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select balance ");
strSql.Append(" from member ");
strSql.Append(" where uid=@uid");
SqlParameter[] parameters =
{
new SqlParameter("@uid", SqlDbType.Int, 4)
};
parameters[0].Value = uid;
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters);
return(obj != DBNull.Value && obj != null?Convert.ToDecimal(obj) : 0);
}
catch { }
return(-1);
}
public int Getid(int CompanyID)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CompanyID ");
strSql.Append(" from Companys ");
strSql.Append(" where CompanyID=@CompanyID");
SqlParameter[] parameters =
{
new SqlParameter("@CompanyID", SqlDbType.Int, 4)
};
parameters[0].Value = CompanyID;
CompanysInfo info = new CompanysInfo();
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters);
return(obj != null && obj != DBNull.Value ? Convert.ToInt32(obj) : 0);
}
catch { }
return(0);
}
public int Add(Companys_costlogInfo model, ref string resultMsg)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Companys_costlog(");
strSql.Append("userid,companyid,amount,description,createtime");
strSql.Append(") values (");
strSql.Append("@userid,@companyid,@amount,@description,@createtime");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@userid", SqlDbType.Int, 4),
new SqlParameter("@companyid", SqlDbType.Int, 4),
new SqlParameter("@amount", SqlDbType.Money, 8),
new SqlParameter("@description", SqlDbType.NVarChar, 255),
new SqlParameter("@createtime", SqlDbType.DateTime)
};
parameters[0].Value = model.userid;
parameters[1].Value = model.companyid;
parameters[2].Value = model.amount;
parameters[3].Value = model.description;
parameters[4].Value = model.createtime;
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
catch (Exception exc)
{ resultMsg = exc.Message; }
return(0);
}
public bool Login(string userNo, string userPassword)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from [student_account]");
strSql.Append(" where stuno=@StuNo and password=@Password");
SqlParameter[] parameters =
{
new SqlParameter("@StuNo", SqlDbType.VarChar, 50),
new SqlParameter("@Password", SqlDbType.VarChar, 50),
};
parameters[0].Value = userNo;
parameters[1].Value = userPassword;
int n = Convert.ToInt32(SqlDbHelper.ExecuteScalar(strSql.ToString(), CommandType.Text, parameters));
if (n == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool Login(Model.AdminAccount model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from [admin_account]");
strSql.Append(" where adminno=@AdminNo and password=@Password");
SqlParameter[] parameters =
{
new SqlParameter("@AdminNo", SqlDbType.VarChar, 50),
new SqlParameter("@Password", SqlDbType.VarChar, 50),
};
parameters[0].Value = model.AdminNo;
parameters[1].Value = model.Password;
int n = Convert.ToInt32(SqlDbHelper.ExecuteScalar(strSql.ToString(), CommandType.Text, parameters));
if (n == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 用户数量
/// </summary>
/// <returns></returns>
public int PostUserValue()
{
string sql = " select count(*) from Users";
return(Convert.ToInt32(SqlDbHelper.ExecuteScalar(sql)));
}
/// <summary>
/// 成交额
/// </summary>
/// <returns></returns>
public int PostCjMoney()
{
string sql = "select Sum(Cbj) from RepayMent join VehicleInfo on VehicleInfo.Cid=RepayMent.Pcid";
return(Convert.ToInt32(SqlDbHelper.ExecuteScalar(sql)));
}
public int Add(articleInfo model, ref string resultMsg)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into article(");
strSql.Append("seo_description,zhaiyao,content,orderby,click,status,is_top,is_red,is_hot,channel_id,is_slide,userid,username,add_time,update_time,category_id,call_index,title,link_url,img_url,seo_title,seo_keywords,companyid");
strSql.Append(") values (");
strSql.Append("@seo_description,@zhaiyao,@content,@orderby,@click,@status,@is_top,@is_red,@is_hot,@channel_id,@is_slide,@userid,@username,@add_time,@update_time,@category_id,@call_index,@title,@link_url,@img_url,@seo_title,@seo_keywords,@companyid");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@seo_description", SqlDbType.NVarChar, 255),
new SqlParameter("@zhaiyao", SqlDbType.NVarChar, 255),
new SqlParameter("@content", SqlDbType.Text),
new SqlParameter("@orderby", SqlDbType.Int, 4),
new SqlParameter("@click", SqlDbType.Int, 4),
new SqlParameter("@status", SqlDbType.TinyInt, 1),
new SqlParameter("@is_top", SqlDbType.TinyInt, 1),
new SqlParameter("@is_red", SqlDbType.TinyInt, 1),
new SqlParameter("@is_hot", SqlDbType.TinyInt, 1),
new SqlParameter("@channel_id", SqlDbType.Int, 4),
new SqlParameter("@is_slide", SqlDbType.TinyInt, 1),
new SqlParameter("@userid", SqlDbType.Int, 4),
new SqlParameter("@username", SqlDbType.NVarChar, 100),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@update_time", SqlDbType.DateTime),
new SqlParameter("@category_id", SqlDbType.Int, 4),
new SqlParameter("@call_index", SqlDbType.NVarChar, 50),
new SqlParameter("@title", SqlDbType.NVarChar, 100),
new SqlParameter("@link_url", SqlDbType.NVarChar, 255),
new SqlParameter("@img_url", SqlDbType.NVarChar, 255),
new SqlParameter("@seo_title", SqlDbType.NVarChar, 255),
new SqlParameter("@seo_keywords", SqlDbType.NVarChar, 255),
new SqlParameter("@companyid", SqlDbType.Int, 4),
};
parameters[0].Value = model.seo_description;
parameters[1].Value = model.zhaiyao;
parameters[2].Value = model.content;
parameters[3].Value = model.orderby;
parameters[4].Value = model.click;
parameters[5].Value = model.status;
parameters[6].Value = model.is_top;
parameters[7].Value = model.is_red;
parameters[8].Value = model.is_hot;
parameters[9].Value = model.channel_id;
parameters[10].Value = model.is_slide;
parameters[11].Value = model.userid;
parameters[12].Value = model.username;
parameters[13].Value = model.add_time;
parameters[14].Value = model.update_time;
parameters[15].Value = model.category_id;
parameters[16].Value = model.call_index;
parameters[17].Value = model.title;
parameters[18].Value = model.link_url;
parameters[19].Value = model.img_url;
parameters[20].Value = model.seo_title;
parameters[21].Value = model.seo_keywords;
parameters[22].Value = model.companyid;
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
catch (Exception exc)
{ resultMsg = exc.Message; }
return(0);
}
/// <summary>
/// 成交量
/// </summary>
/// <returns></returns>
public int PostCjCount()
{
string sql = "select count(*) from VehicleInfo where Czt != 1";
return(Convert.ToInt32(SqlDbHelper.ExecuteScalar(sql)));
}
