public bool Exists(string identifyNo, out bool isSuccess, out string errMessage)
{
var strSql = new StringBuilder();
strSql.Append("select count(1) from Identify");
strSql.Append(" where I_No=@I_No ");
SqlParameter[] parameters =
{
new SqlParameter("@I_No", SqlDbType.Int)
};
parameters[0].Value = identifyNo;
return(DbHelperSql.GetInstance().Exists(strSql.ToString(), out isSuccess, out errMessage, parameters));
}
public DataSet GetSet(string strWhere, int num, out bool isSuccess, out string errMessage)
{
var strSql = new StringBuilder();
strSql.Append("select ");
if (num > 0)
{
strSql.Append(" top " + num);
}
strSql.Append(" * ");
strSql.Append(" FROM Identify ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelperSql.GetInstance().Query(strSql.ToString(), out isSuccess, out errMessage));
}
public bool Update(Identify model, out bool isSuccess, out string errMessage)
{
var strSql = new StringBuilder();
strSql.Append("update Users set ");
strSql.Append("I_Date = @I_Date,");
strSql.Append("I_Code = @I_Code,");
SqlParameter[] parameters =
{
new SqlParameter("@I_Date", SqlDbType.DateTime),
new SqlParameter("@U_intro", SqlDbType.VarChar, 10)
};
parameters[0].Value = model.Date;
parameters[1].Value = model.IdentityCode;
DbHelperSql.GetInstance().ExecuteSql(strSql.ToString(), out isSuccess, out errMessage, parameters);
return(isSuccess);
}
public Identify GetModel(string identifyNo, out bool isSuccess, out string errMessage)
{
var strSql = new StringBuilder();
strSql.Append("select top 1 * from Identify ");
strSql.Append("where I_No = @I_No ");
SqlParameter[] parameters =
{
new SqlParameter("@I_No", SqlDbType.Int)
};
parameters[0].Value = identifyNo;
var ds = DbHelperSql.GetInstance().Query(strSql.ToString(), out isSuccess, out errMessage, parameters);
if (isSuccess == false)//查询失败返回空
{
return(null);
}
return(ds.Tables[0].Rows.Count > 0
? DataRowToModel(ds.Tables[0].Rows[0], out isSuccess, out errMessage)
: null);
}
public bool Add(Identify model, out bool isSuccess, out string errMessage)
{
var strSql = new StringBuilder();
strSql.Append("insert into Identify(");
strSql.Append("I_No,I_Date,I_Code)");
strSql.Append(" values(@I_No,@I_Date,@I_Code)");
SqlParameter[] parameters =
{
new SqlParameter("@I_No", SqlDbType.Int),
new SqlParameter("@I_Date", SqlDbType.DateTime),
new SqlParameter("@I_Code", SqlDbType.VarChar, 10)
};
parameters[0].Value = model.No;
parameters[1].Value = model.Date;
parameters[2].Value = model.IdentityCode;
return(DbHelperSql.GetInstance()
.ExecuteSql(strSql.ToString(), out isSuccess, out errMessage, parameters) > 0);
}
