/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SHUniversity.KPI.Model.UserKPI model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UserKPI set ");
strSql.Append("KPINumber=@KPINumber,");
strSql.Append("KPIYear=@KPIYear,");
strSql.Append("WorkID=@WorkID,");
strSql.Append("Creator=@Creator,");
strSql.Append("CreatDate=@CreatDate,");
strSql.Append("ScoreYear=@ScoreYear,");
strSql.Append("Status=@Status");
strSql.Append("sujUser=@sujUser");
strSql.Append("sujWorkID=@sujWorkID");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@KPINumber", SqlDbType.NVarChar, 50),
new SqlParameter("@KPIYear", SqlDbType.Int, 4),
new SqlParameter("@WorkID", SqlDbType.NVarChar, 50),
new SqlParameter("@Creator", SqlDbType.NVarChar, 50),
new SqlParameter("@CreatDate", SqlDbType.DateTime),
new SqlParameter("@ScoreYear", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@sujUser", SqlDbType.NVarChar, 50),
new SqlParameter("@sujWorkID", SqlDbType.NVarChar, 50),
};
parameters[0].Value = model.KPINumber;
parameters[1].Value = model.KPIYear;
parameters[2].Value = model.WorkID;
parameters[3].Value = model.Creator;
parameters[4].Value = model.CreatDate;
parameters[5].Value = model.ScoreYear;
parameters[6].Value = model.Status;
parameters[7].Value = model.ID;
parameters[8].Value = model.sujUser;
parameters[9].Value = model.sujWorkID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SHUniversity.KPI.Model.UserKPI DataRowToModel(DataRow row)
{
SHUniversity.KPI.Model.UserKPI model = new SHUniversity.KPI.Model.UserKPI();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["KPINumber"] != null)
{
model.KPINumber = row["KPINumber"].ToString();
}
if (row["KPIYear"] != null && row["KPIYear"].ToString() != "")
{
model.KPIYear = int.Parse(row["KPIYear"].ToString());
}
if (row["WorkID"] != null)
{
model.WorkID = row["WorkID"].ToString();
}
if (row["Creator"] != null)
{
model.Creator = row["Creator"].ToString();
}
if (row["CreatDate"] != null && row["CreatDate"].ToString() != "")
{
model.CreatDate = DateTime.Parse(row["CreatDate"].ToString());
}
if (row["ScoreYear"] != null && row["ScoreYear"].ToString() != "")
{
model.ScoreYear = int.Parse(row["ScoreYear"].ToString());
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["sujUser"] != null)
{
model.sujUser = row["sujUser"].ToString();
}
if (row["sujWorkID"] != null)
{
model.sujWorkID = row["sujWorkID"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SHUniversity.KPI.Model.UserKPI model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UserKPI(");
strSql.Append("KPINumber,KPIYear,WorkID,Creator,CreatDate,ScoreYear,Status,sujUser,sujWorkID)");
strSql.Append(" values (");
strSql.Append("@KPINumber,@KPIYear,@WorkID,@Creator,@CreatDate,@ScoreYear,@Status,@sujUser,@sujWorkID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@KPINumber", SqlDbType.NVarChar, 50),
new SqlParameter("@KPIYear", SqlDbType.Int, 4),
new SqlParameter("@WorkID", SqlDbType.NVarChar, 50),
new SqlParameter("@Creator", SqlDbType.NVarChar, 50),
new SqlParameter("@CreatDate", SqlDbType.DateTime),
new SqlParameter("@ScoreYear", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@sujUser", SqlDbType.NVarChar, 50),
new SqlParameter("@sujWorkID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.KPINumber;
parameters[1].Value = model.KPIYear;
parameters[2].Value = model.WorkID;
parameters[3].Value = model.Creator;
parameters[4].Value = model.CreatDate;
parameters[5].Value = model.ScoreYear;
parameters[6].Value = model.Status;
parameters[7].Value = model.sujUser;
parameters[8].Value = model.sujWorkID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SHUniversity.KPI.Model.UserKPI GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from UserKPI ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
SHUniversity.KPI.Model.UserKPI model = new SHUniversity.KPI.Model.UserKPI();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
