/// <summary>
/// 更新一条数据
/// </summary>
public static Hashtable Update(yny_005.Model.ObjSubUser model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("update ObjSubUser set ");
strSql.Append("SubID=@SubID,");
strSql.Append("MID=@MID,");
strSql.Append("ResultOne=@ResultOne,");
strSql.Append("ResultTwo=@ResultTwo,");
strSql.Append("ResultAvg=@ResultAvg,");
strSql.Append("RFangFa=@RFangFa,");
strSql.Append("RSheBei=@RSheBei,");
strSql.Append("RYiChang=@RYiChang,");
strSql.Append("RPerson=@RPerson,");
strSql.Append("RYangPinID=@RYangPinID,");
strSql.Append("ResultImgUrl=@ResultImgUrl,");
strSql.Append("SState=@SState,");
strSql.Append("Spare=@Spare,");
strSql.Append("SpInt=@SpInt");
strSql.Append(" where ID=@ID");
strSql.AppendFormat(" ;select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@SubID", SqlDbType.Int, 4),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@ResultOne", SqlDbType.VarChar, 50),
new SqlParameter("@ResultTwo", SqlDbType.VarChar, 50),
new SqlParameter("@ResultAvg", SqlDbType.VarChar, 50),
new SqlParameter("@RFangFa", SqlDbType.VarChar, 500),
new SqlParameter("@RSheBei", SqlDbType.VarChar, 500),
new SqlParameter("@RYiChang", SqlDbType.VarChar, 500),
new SqlParameter("@RPerson", SqlDbType.VarChar, 50),
new SqlParameter("@RYangPinID", SqlDbType.Int, 4),
new SqlParameter("@ResultImgUrl", SqlDbType.VarChar, 250),
new SqlParameter("@SState", SqlDbType.Int, 4),
new SqlParameter("@Spare", SqlDbType.VarChar, 250),
new SqlParameter("@SpInt", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.SubID;
parameters[1].Value = model.MID;
parameters[2].Value = model.ResultOne;
parameters[3].Value = model.ResultTwo;
parameters[4].Value = model.ResultAvg;
parameters[5].Value = model.RFangFa;
parameters[6].Value = model.RSheBei;
parameters[7].Value = model.RYiChang;
parameters[8].Value = model.RPerson;
parameters[9].Value = model.RYangPinID;
parameters[10].Value = model.ResultImgUrl;
parameters[11].Value = model.SState;
parameters[12].Value = model.Spare;
parameters[13].Value = model.SpInt;
parameters[14].Value = model.ID;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(yny_005.Model.ObjSubUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ObjSubUser(");
strSql.Append("SubID,MID,ResultOne,ResultTwo,ResultAvg,RFangFa,RSheBei,RYiChang,RPerson,RYangPinID,ResultImgUrl,SState,Spare,SpInt)");
strSql.Append(" values (");
strSql.Append("@SubID,@MID,@ResultOne,@ResultTwo,@ResultAvg,@RFangFa,@RSheBei,@RYiChang,@RPerson,@RYangPinID,@ResultImgUrl,@SState,@Spare,@SpInt)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@SubID", SqlDbType.Int, 4),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@ResultOne", SqlDbType.VarChar, 50),
new SqlParameter("@ResultTwo", SqlDbType.VarChar, 50),
new SqlParameter("@ResultAvg", SqlDbType.VarChar, 50),
new SqlParameter("@RFangFa", SqlDbType.VarChar, 500),
new SqlParameter("@RSheBei", SqlDbType.VarChar, 500),
new SqlParameter("@RYiChang", SqlDbType.VarChar, 500),
new SqlParameter("@RPerson", SqlDbType.VarChar, 50),
new SqlParameter("@RYangPinID", SqlDbType.Int, 4),
new SqlParameter("@ResultImgUrl", SqlDbType.VarChar, 250),
new SqlParameter("@SState", SqlDbType.Int, 4),
new SqlParameter("@Spare", SqlDbType.VarChar, 250),
new SqlParameter("@SpInt", SqlDbType.Int, 4)
};
parameters[0].Value = model.SubID;
parameters[1].Value = model.MID;
parameters[2].Value = model.ResultOne;
parameters[3].Value = model.ResultTwo;
parameters[4].Value = model.ResultAvg;
parameters[5].Value = model.RFangFa;
parameters[6].Value = model.RSheBei;
parameters[7].Value = model.RYiChang;
parameters[8].Value = model.RPerson;
parameters[9].Value = model.RYangPinID;
parameters[10].Value = model.ResultImgUrl;
parameters[11].Value = model.SState;
parameters[12].Value = model.Spare;
parameters[13].Value = model.SpInt;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static Hashtable Add(yny_005.Model.ObjSubUser model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ObjSubUser(");
strSql.Append("SubID,MID,ResultOne,ResultTwo,ResultAvg,RFangFa,RSheBei,RYiChang,RPerson,RYangPinID,ResultImgUrl,SState,Spare,SpInt)");
strSql.Append(" values (");
strSql.Append("@SubID,@MID,@ResultOne,@ResultTwo,@ResultAvg,@RFangFa,@RSheBei,@RYiChang,@RPerson,@RYangPinID,@ResultImgUrl,@SState,@Spare,@SpInt)");
SqlParameter[] parameters =
{
new SqlParameter("@SubID", SqlDbType.Int, 4),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@ResultOne", SqlDbType.VarChar, 50),
new SqlParameter("@ResultTwo", SqlDbType.VarChar, 50),
new SqlParameter("@ResultAvg", SqlDbType.VarChar, 50),
new SqlParameter("@RFangFa", SqlDbType.VarChar, 500),
new SqlParameter("@RSheBei", SqlDbType.VarChar, 500),
new SqlParameter("@RYiChang", SqlDbType.VarChar, 500),
new SqlParameter("@RPerson", SqlDbType.VarChar, 50),
new SqlParameter("@RYangPinID", SqlDbType.Int, 4),
new SqlParameter("@ResultImgUrl", SqlDbType.VarChar, 250),
new SqlParameter("@SState", SqlDbType.Int, 4),
new SqlParameter("@Spare", SqlDbType.VarChar, 250),
new SqlParameter("@SpInt", SqlDbType.Int, 4)
};
parameters[0].Value = model.SubID;
parameters[1].Value = model.MID;
parameters[2].Value = model.ResultOne;
parameters[3].Value = model.ResultTwo;
parameters[4].Value = model.ResultAvg;
parameters[5].Value = model.RFangFa;
parameters[6].Value = model.RSheBei;
parameters[7].Value = model.RYiChang;
parameters[8].Value = model.RPerson;
parameters[9].Value = model.RYangPinID;
parameters[10].Value = model.ResultImgUrl;
parameters[11].Value = model.SState;
parameters[12].Value = model.Spare;
parameters[13].Value = model.SpInt;
string guid = Guid.NewGuid().ToString();
strSql.AppendFormat("; select '{0}'", guid);
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
public static yny_005.Model.ObjSubUser GetModeluser(int SpInt)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,SubID,MID,ResultOne,ResultTwo,ResultAvg,RFangFa,RSheBei,RYiChang,RPerson,RYangPinID,ResultImgUrl,SState,Spare,SpInt from ObjSubUser ");
strSql.Append(" where SpInt=@SpInt");
SqlParameter[] parameters =
{
new SqlParameter("@SpInt", SqlDbType.Int, 4)
};
parameters[0].Value = SpInt;
yny_005.Model.ObjSubUser model = new yny_005.Model.ObjSubUser();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static yny_005.Model.ObjSubUser DataRowToModel(DataRow row)
{
yny_005.Model.ObjSubUser model = new yny_005.Model.ObjSubUser();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["SubID"] != null && row["SubID"].ToString() != "")
{
model.SubID = int.Parse(row["SubID"].ToString());
}
if (row["MID"] != null)
{
model.MID = row["MID"].ToString();
}
if (row["ResultOne"] != null)
{
model.ResultOne = row["ResultOne"].ToString();
}
if (row["ResultTwo"] != null)
{
model.ResultTwo = row["ResultTwo"].ToString();
}
if (row["ResultAvg"] != null)
{
model.ResultAvg = row["ResultAvg"].ToString();
}
if (row["RFangFa"] != null)
{
model.RFangFa = row["RFangFa"].ToString();
}
if (row["RSheBei"] != null)
{
model.RSheBei = row["RSheBei"].ToString();
}
if (row["RYiChang"] != null)
{
model.RYiChang = row["RYiChang"].ToString();
}
if (row["RPerson"] != null)
{
model.RPerson = row["RPerson"].ToString();
}
if (row["RYangPinID"] != null && row["RYangPinID"].ToString() != "")
{
model.RYangPinID = int.Parse(row["RYangPinID"].ToString());
}
if (row["ResultImgUrl"] != null)
{
model.ResultImgUrl = row["ResultImgUrl"].ToString();
}
if (row["SState"] != null && row["SState"].ToString() != "")
{
model.SState = int.Parse(row["SState"].ToString());
}
if (row["Spare"] != null)
{
model.Spare = row["Spare"].ToString();
}
if (row["SpInt"] != null && row["SpInt"].ToString() != "")
{
model.SpInt = int.Parse(row["SpInt"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(yny_005.Model.ObjSubUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ObjSubUser set ");
strSql.Append("SubID=@SubID,");
strSql.Append("MID=@MID,");
strSql.Append("ResultOne=@ResultOne,");
strSql.Append("ResultTwo=@ResultTwo,");
strSql.Append("ResultAvg=@ResultAvg,");
strSql.Append("RFangFa=@RFangFa,");
strSql.Append("RSheBei=@RSheBei,");
strSql.Append("RYiChang=@RYiChang,");
strSql.Append("RPerson=@RPerson,");
strSql.Append("RYangPinID=@RYangPinID,");
strSql.Append("ResultImgUrl=@ResultImgUrl,");
strSql.Append("SState=@SState,");
strSql.Append("Spare=@Spare,");
strSql.Append("SpInt=@SpInt");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@SubID", SqlDbType.Int, 4),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@ResultOne", SqlDbType.VarChar, 50),
new SqlParameter("@ResultTwo", SqlDbType.VarChar, 50),
new SqlParameter("@ResultAvg", SqlDbType.VarChar, 50),
new SqlParameter("@RFangFa", SqlDbType.VarChar, 500),
new SqlParameter("@RSheBei", SqlDbType.VarChar, 500),
new SqlParameter("@RYiChang", SqlDbType.VarChar, 500),
new SqlParameter("@RPerson", SqlDbType.VarChar, 50),
new SqlParameter("@RYangPinID", SqlDbType.Int, 4),
new SqlParameter("@ResultImgUrl", SqlDbType.VarChar, 250),
new SqlParameter("@SState", SqlDbType.Int, 4),
new SqlParameter("@Spare", SqlDbType.VarChar, 250),
new SqlParameter("@SpInt", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.SubID;
parameters[1].Value = model.MID;
parameters[2].Value = model.ResultOne;
parameters[3].Value = model.ResultTwo;
parameters[4].Value = model.ResultAvg;
parameters[5].Value = model.RFangFa;
parameters[6].Value = model.RSheBei;
parameters[7].Value = model.RYiChang;
parameters[8].Value = model.RPerson;
parameters[9].Value = model.RYangPinID;
parameters[10].Value = model.ResultImgUrl;
parameters[11].Value = model.SState;
parameters[12].Value = model.Spare;
parameters[13].Value = model.SpInt;
parameters[14].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
