/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(yny_005.Model.ObjUserApply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ObjUserApply(");
strSql.Append("ObjID,MID,BaoMingCode,DanWeiName,ZiGeZhengShu,ZhengShuCode,CreateDate,ComDate,SubID,BaoMingImgUrl,FeiYongImgUrl,SState,BMInt,ReSpare,YZState)");
strSql.Append(" values (");
strSql.Append("@ObjID,@MID,@BaoMingCode,@DanWeiName,@ZiGeZhengShu,@ZhengShuCode,@CreateDate,@ComDate,@SubID,@BaoMingImgUrl,@FeiYongImgUrl,@SState,@BMInt,@ReSpare,@YZState)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ObjID", SqlDbType.Int, 4),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@BaoMingCode", SqlDbType.VarChar, 50),
new SqlParameter("@DanWeiName", SqlDbType.VarChar, 50),
new SqlParameter("@ZiGeZhengShu", SqlDbType.VarChar, 250),
new SqlParameter("@ZhengShuCode", SqlDbType.VarChar, 250),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@ComDate", SqlDbType.DateTime),
new SqlParameter("@SubID", SqlDbType.VarChar, 50),
new SqlParameter("@BaoMingImgUrl", SqlDbType.VarChar, 250),
new SqlParameter("@FeiYongImgUrl", SqlDbType.VarChar, 250),
new SqlParameter("@SState", SqlDbType.Int, 4),new SqlParameter("@BMInt",SqlDbType.Int, 4), new SqlParameter("@ReSpare", SqlDbType.VarChar, 250), new SqlParameter("@YZState", SqlDbType.Int, 4)
};
parameters[0].Value = model.ObjID;
parameters[1].Value = model.MID;
parameters[2].Value = model.BaoMingCode;
parameters[3].Value = model.DanWeiName;
parameters[4].Value = model.ZiGeZhengShu;
parameters[5].Value = model.ZhengShuCode;
parameters[6].Value = model.CreateDate;
parameters[7].Value = model.ComDate;
parameters[8].Value = model.SubID;
parameters[9].Value = model.BaoMingImgUrl;
parameters[10].Value = model.FeiYongImgUrl;
parameters[11].Value = model.SState;
parameters[12].Value = model.BMInt;
parameters[13].Value = model.ReSpare;
parameters[14].Value = model.YZState;
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.ObjUserApply model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ObjUserApply(");
strSql.Append("ObjID,MID,BaoMingCode,DanWeiName,ZiGeZhengShu,ZhengShuCode,CreateDate,ComDate,SubID,BaoMingImgUrl,FeiYongImgUrl,SState,BMInt,ReSpare,YZState)");
strSql.Append(" values (");
strSql.Append("@ObjID,@MID,@BaoMingCode,@DanWeiName,@ZiGeZhengShu,@ZhengShuCode,@CreateDate,@ComDate,@SubID,@BaoMingImgUrl,@FeiYongImgUrl,@SState,@BMInt,@ReSpare,@YZState)");
SqlParameter[] parameters =
{
new SqlParameter("@ObjID", SqlDbType.Int, 4),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@BaoMingCode", SqlDbType.VarChar, 50),
new SqlParameter("@DanWeiName", SqlDbType.VarChar, 50),
new SqlParameter("@ZiGeZhengShu", SqlDbType.VarChar, 250),
new SqlParameter("@ZhengShuCode", SqlDbType.VarChar, 250),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@ComDate", SqlDbType.DateTime),
new SqlParameter("@SubID", SqlDbType.VarChar, 50),
new SqlParameter("@BaoMingImgUrl", SqlDbType.VarChar, 250),
new SqlParameter("@FeiYongImgUrl", SqlDbType.VarChar, 250),
new SqlParameter("@SState", SqlDbType.Int, 4),new SqlParameter("@BMInt",SqlDbType.Int, 4), new SqlParameter("@ReSpare", SqlDbType.VarChar, 250), new SqlParameter("@YZState", SqlDbType.Int, 4)
};
parameters[0].Value = model.ObjID;
parameters[1].Value = model.MID;
parameters[2].Value = model.BaoMingCode;
parameters[3].Value = model.DanWeiName;
parameters[4].Value = model.ZiGeZhengShu;
parameters[5].Value = model.ZhengShuCode;
parameters[6].Value = model.CreateDate;
parameters[7].Value = model.ComDate;
parameters[8].Value = model.SubID;
parameters[9].Value = model.BaoMingImgUrl;
parameters[10].Value = model.FeiYongImgUrl;
parameters[11].Value = model.SState;
parameters[12].Value = model.BMInt;
parameters[13].Value = model.ReSpare;
parameters[14].Value = model.YZState;
string guid = Guid.NewGuid().ToString();
strSql.AppendFormat("; select '{0}'", guid);
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static yny_005.Model.ObjUserApply GetModelOID(string OID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,ObjID,MID,BaoMingCode,DanWeiName,ZiGeZhengShu,ZhengShuCode,CreateDate,ComDate,SubID,BaoMingImgUrl,FeiYongImgUrl,SState,BMInt,ReSpare,YZState from ObjUserApply ");
strSql.Append(" where BaoMingCode=@BaoMingCode");
SqlParameter[] parameters =
{
new SqlParameter("@BaoMingCode", SqlDbType.VarChar, 50)
};
parameters[0].Value = OID;
yny_005.Model.ObjUserApply model = new yny_005.Model.ObjUserApply();
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.ObjUserApply DataRowToModel(DataRow row)
{
yny_005.Model.ObjUserApply model = new yny_005.Model.ObjUserApply();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["ObjID"] != null && row["ObjID"].ToString() != "")
{
model.ObjID = int.Parse(row["ObjID"].ToString());
}
if (row["MID"] != null)
{
model.MID = row["MID"].ToString();
}
if (row["BaoMingCode"] != null)
{
model.BaoMingCode = row["BaoMingCode"].ToString();
}
if (row["DanWeiName"] != null)
{
model.DanWeiName = row["DanWeiName"].ToString();
}
if (row["ZiGeZhengShu"] != null)
{
model.ZiGeZhengShu = row["ZiGeZhengShu"].ToString();
}
if (row["ZhengShuCode"] != null)
{
model.ZhengShuCode = row["ZhengShuCode"].ToString();
}
if (row["CreateDate"] != null && row["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(row["CreateDate"].ToString());
}
if (row["ComDate"] != null && row["ComDate"].ToString() != "")
{
model.ComDate = DateTime.Parse(row["ComDate"].ToString());
}
if (row["SubID"] != null)
{
model.SubID = row["SubID"].ToString();
}
if (row["BaoMingImgUrl"] != null)
{
model.BaoMingImgUrl = row["BaoMingImgUrl"].ToString();
}
if (row["FeiYongImgUrl"] != null)
{
model.FeiYongImgUrl = row["FeiYongImgUrl"].ToString();
}
if (row["SState"] != null && row["SState"].ToString() != "")
{
model.SState = int.Parse(row["SState"].ToString());
}
if (row["BMInt"] != null && row["BMInt"].ToString() != "")
{
model.BMInt = int.Parse(row["BMInt"].ToString());
}
if (row["ReSpare"] != null)
{
model.ReSpare = row["ReSpare"].ToString();
}
if (row["YZState"] != null && row["YZState"].ToString() != "")
{
model.YZState = int.Parse(row["YZState"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static Hashtable Update(yny_005.Model.ObjUserApply model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("update ObjUserApply set ");
strSql.Append("ObjID=@ObjID,");
strSql.Append("MID=@MID,");
strSql.Append("BaoMingCode=@BaoMingCode,");
strSql.Append("DanWeiName=@DanWeiName,");
strSql.Append("ZiGeZhengShu=@ZiGeZhengShu,");
strSql.Append("ZhengShuCode=@ZhengShuCode,");
strSql.Append("CreateDate=@CreateDate,");
strSql.Append("ComDate=@ComDate,");
strSql.Append("SubID=@SubID,");
strSql.Append("BaoMingImgUrl=@BaoMingImgUrl,");
strSql.Append("FeiYongImgUrl=@FeiYongImgUrl,");
strSql.Append("SState=@SState,");
strSql.Append("BMInt=@BMInt,");
strSql.Append("ReSpare=@ReSpare,");
strSql.Append("YZState=@YZState");
strSql.Append(" where ID=@ID");
strSql.AppendFormat(" ;select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@ObjID", SqlDbType.Int, 4),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@BaoMingCode", SqlDbType.VarChar, 50),
new SqlParameter("@DanWeiName", SqlDbType.VarChar, 50),
new SqlParameter("@ZiGeZhengShu", SqlDbType.VarChar, 250),
new SqlParameter("@ZhengShuCode", SqlDbType.VarChar, 250),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@ComDate", SqlDbType.DateTime),
new SqlParameter("@SubID", SqlDbType.VarChar, 50),
new SqlParameter("@BaoMingImgUrl", SqlDbType.VarChar, 250),
new SqlParameter("@FeiYongImgUrl", SqlDbType.VarChar, 250),
new SqlParameter("@SState", SqlDbType.Int, 4),
new SqlParameter("@BMInt", SqlDbType.Int, 4),
new SqlParameter("@ReSpare", SqlDbType.VarChar, 250),
new SqlParameter("@YZState", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ObjID;
parameters[1].Value = model.MID;
parameters[2].Value = model.BaoMingCode;
parameters[3].Value = model.DanWeiName;
parameters[4].Value = model.ZiGeZhengShu;
parameters[5].Value = model.ZhengShuCode;
parameters[6].Value = model.CreateDate;
parameters[7].Value = model.ComDate;
parameters[8].Value = model.SubID;
parameters[9].Value = model.BaoMingImgUrl;
parameters[10].Value = model.FeiYongImgUrl;
parameters[11].Value = model.SState;
parameters[12].Value = model.BMInt;
parameters[13].Value = model.ReSpare;
parameters[14].Value = model.YZState;
parameters[15].Value = model.ID;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(yny_005.Model.ObjUserApply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ObjUserApply set ");
strSql.Append("ObjID=@ObjID,");
strSql.Append("MID=@MID,");
strSql.Append("BaoMingCode=@BaoMingCode,");
strSql.Append("DanWeiName=@DanWeiName,");
strSql.Append("ZiGeZhengShu=@ZiGeZhengShu,");
strSql.Append("ZhengShuCode=@ZhengShuCode,");
strSql.Append("CreateDate=@CreateDate,");
strSql.Append("ComDate=@ComDate,");
strSql.Append("SubID=@SubID,");
strSql.Append("BaoMingImgUrl=@BaoMingImgUrl,");
strSql.Append("FeiYongImgUrl=@FeiYongImgUrl,");
strSql.Append("SState=@SState,");
strSql.Append("BMInt=@BMInt,");
strSql.Append("ReSpare=@ReSpare,");
strSql.Append("YZState=@YZState");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ObjID", SqlDbType.Int, 4),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@BaoMingCode", SqlDbType.VarChar, 50),
new SqlParameter("@DanWeiName", SqlDbType.VarChar, 50),
new SqlParameter("@ZiGeZhengShu", SqlDbType.VarChar, 250),
new SqlParameter("@ZhengShuCode", SqlDbType.VarChar, 250),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@ComDate", SqlDbType.DateTime),
new SqlParameter("@SubID", SqlDbType.VarChar, 50),
new SqlParameter("@BaoMingImgUrl", SqlDbType.VarChar, 250),
new SqlParameter("@FeiYongImgUrl", SqlDbType.VarChar, 250),
new SqlParameter("@SState", SqlDbType.Int, 4),
new SqlParameter("@BMInt", SqlDbType.Int, 4),
new SqlParameter("@ReSpare", SqlDbType.VarChar, 250),
new SqlParameter("@YZState", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ObjID;
parameters[1].Value = model.MID;
parameters[2].Value = model.BaoMingCode;
parameters[3].Value = model.DanWeiName;
parameters[4].Value = model.ZiGeZhengShu;
parameters[5].Value = model.ZhengShuCode;
parameters[6].Value = model.CreateDate;
parameters[7].Value = model.ComDate;
parameters[8].Value = model.SubID;
parameters[9].Value = model.BaoMingImgUrl;
parameters[10].Value = model.FeiYongImgUrl;
parameters[11].Value = model.SState;
parameters[12].Value = model.BMInt;
parameters[13].Value = model.ReSpare;
parameters[14].Value = model.YZState;
parameters[15].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
