/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.project_item_flow_1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update project_item_flow_1 set ");
strSql.Append("pif_time=@pif_time,");
strSql.Append("psi_sid=@psi_sid,");
strSql.Append("wf_text=@wf_text,");
strSql.Append("v1=@v1,");
strSql.Append("v2=@v2,");
strSql.Append("n1=@n1,");
strSql.Append("n2=@n2");
strSql.Append(" where sid=@sid");
SqlParameter[] parameters =
{
new SqlParameter("@pif_time", SqlDbType.DateTime),
new SqlParameter("@psi_sid", SqlDbType.Int, 4),
new SqlParameter("@wf_text", SqlDbType.NVarChar, 4000),
new SqlParameter("@v1", SqlDbType.NVarChar, 400),
new SqlParameter("@v2", SqlDbType.NVarChar, 400),
new SqlParameter("@n1", SqlDbType.Int, 4),
new SqlParameter("@n2", SqlDbType.Int, 4),
new SqlParameter("@sid", SqlDbType.Int, 4)
};
parameters[0].Value = model.pif_time;
parameters[1].Value = model.psi_sid;
parameters[2].Value = model.wf_text;
parameters[3].Value = model.v1;
parameters[4].Value = model.v2;
parameters[5].Value = model.n1;
parameters[6].Value = model.n2;
parameters[7].Value = model.sid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.project_item_flow_1 DataRowToModel(DataRow row)
{
Maticsoft.Model.project_item_flow_1 model = new Maticsoft.Model.project_item_flow_1();
if (row != null)
{
if (row["sid"] != null && row["sid"].ToString() != "")
{
model.sid = int.Parse(row["sid"].ToString());
}
if (row["pif_time"] != null && row["pif_time"].ToString() != "")
{
model.pif_time = DateTime.Parse(row["pif_time"].ToString());
}
if (row["psi_sid"] != null && row["psi_sid"].ToString() != "")
{
model.psi_sid = int.Parse(row["psi_sid"].ToString());
}
if (row["wf_text"] != null)
{
model.wf_text = row["wf_text"].ToString();
}
if (row["v1"] != null)
{
model.v1 = row["v1"].ToString();
}
if (row["v2"] != null)
{
model.v2 = row["v2"].ToString();
}
if (row["n1"] != null && row["n1"].ToString() != "")
{
model.n1 = int.Parse(row["n1"].ToString());
}
if (row["n2"] != null && row["n2"].ToString() != "")
{
model.n2 = int.Parse(row["n2"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.project_item_flow_1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into project_item_flow_1(");
strSql.Append("pif_time,psi_sid,wf_text,v1,v2,n1,n2)");
strSql.Append(" values (");
strSql.Append("@pif_time,@psi_sid,@wf_text,@v1,@v2,@n1,@n2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@pif_time", SqlDbType.DateTime),
new SqlParameter("@psi_sid", SqlDbType.Int, 4),
new SqlParameter("@wf_text", SqlDbType.NVarChar, 4000),
new SqlParameter("@v1", SqlDbType.NVarChar, 400),
new SqlParameter("@v2", SqlDbType.NVarChar, 400),
new SqlParameter("@n1", SqlDbType.Int, 4),
new SqlParameter("@n2", SqlDbType.Int, 4)
};
parameters[0].Value = model.pif_time;
parameters[1].Value = model.psi_sid;
parameters[2].Value = model.wf_text;
parameters[3].Value = model.v1;
parameters[4].Value = model.v2;
parameters[5].Value = model.n1;
parameters[6].Value = model.n2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.project_item_flow_1 GetModel(int sid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 sid,pif_time,psi_sid,wf_text,v1,v2,n1,n2 from project_item_flow_1 ");
strSql.Append(" where sid=@sid");
SqlParameter[] parameters =
{
new SqlParameter("@sid", SqlDbType.Int, 4)
};
parameters[0].Value = sid;
Maticsoft.Model.project_item_flow_1 model = new Maticsoft.Model.project_item_flow_1();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
