string SQL = string.Empty; //保持SQL语句
/// <summary>
/// 判断表是否存在
/// </summary>
/// <returns></returns>
public bool CheckData()
{
bool RetrunValue = false;
SQL = "select count(*) from dbo.sysobjects where id=object_id('users') and ObjectProperty(id,N'IsUserTable')=1";
int row = Convert.ToInt32(mySqlconn.ExecuteSql(SQL));
if (row > 0)
{
RetrunValue = true;
}
return(RetrunValue);
}
public string GetUserPassword(string paramUserName)
{
Sqlconn mySqlconn = new Sqlconn();
DataSet myDs = new DataSet();
string returnValue = string.Empty;
string strSql = "select passwd from user where 1=1";
if (paramUserName.Length > 0)
{
strSql += " and userName ='******'";
myDs = mySqlconn.Query(strSql);
if (myDs.Tables.Count > 0 && myDs.Tables[0].Rows.Count > 0)
{
returnValue = mySqlconn.ExecuteSql(strSql);
return(returnValue);
}
return(returnValue);
}
return(returnValue);
}
/// <summary>
/// 获取价格最大值
/// </summary>
/// <param name="paramUserName"></param>
/// <returns></returns>
public double GetPrice()
{
double RetuenValue = 0.0;
SQL = "select isnull (MaxPrice,1) as MaxPrice from PriceMax where 1=1 ";
RetuenValue = Convert.ToDouble(mySqlconn.ExecuteSql(SQL));
return(RetuenValue);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Model.MoIRoleInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_RoleInfo(");
strSql.Append("RoleID,RoleName,Remark)");
strSql.Append(" values (");
strSql.Append("@RoleID,@RoleName,@Remark)");
SqlParameter[] parameters =
{
new SqlParameter("@RoleID", SqlDbType.Int, 4),
new SqlParameter("@RoleName", SqlDbType.NVarChar, 20),
new SqlParameter("@Remark", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.RoleID;
parameters[1].Value = model.RoleName;
parameters[2].Value = model.Remark;
mySqlconn.ExecuteSql(strSql.ToString(), parameters);
}
public bool Add(Model.Mo_Project model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into project ");
strSql.Append("(project_no, project_name, project_header, project_start_date, project_end_date, project_company, project_contact, contact_phone, remark) ");
strSql.Append("values ");
strSql.Append("(@project_no,@project_name,@project_header,@project_start_date,@project_end_date,@project_company,@project_contact,@contact_phone,@remark)");
SqlParameter[] parameters =
{
new SqlParameter("@project_no", SqlDbType.NVarChar),
new SqlParameter("@project_name", SqlDbType.VarChar),
new SqlParameter("@project_header", SqlDbType.NVarChar),
new SqlParameter("@project_start_date", SqlDbType.DateTime),
new SqlParameter("@project_end_date", SqlDbType.DateTime),
new SqlParameter("@project_company", SqlDbType.NVarChar),
new SqlParameter("@project_contact", SqlDbType.NVarChar),
new SqlParameter("@contact_phone", SqlDbType.NVarChar),
new SqlParameter("@remark", SqlDbType.NVarChar)
};
parameters[0].Value = model.projectNo;
parameters[1].Value = model.projectName;
parameters[2].Value = model.projectHeader;
parameters[3].Value = model.projectStartDate;
parameters[4].Value = model.projectEndDate;
parameters[5].Value = model.projectCompany;
parameters[6].Value = model.projectContact;
parameters[7].Value = model.contactPhone;
parameters[8].Value = model.remark;
int rows = mySqlconn.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
