public static int UpdateTbl_FlowFormWord(Tbl_FlowFormWord tbl_flowformword)
{
WebCommon.Public.WriteLog("Ð޸ĶÌÓ" + tbl_flowformword.IFW_Name);
tbl_flowformword.DealUser = WebCommon.Public.GetUserName();
tbl_flowformword.DealTime = DateTime.Now;
return(new Tbl_FlowFormWordService().UpdateTbl_FlowFormWordById(tbl_flowformword));
}
public int AddTbl_FlowFormWord(Tbl_FlowFormWord tbl_flowformword)
{
string sql = "insert into [Tbl_FlowFormWord] ([FlowFormID],[IFW_Name],[DealUser]) values (@FlowFormID,@IFW_Name,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@FlowFormID", tbl_flowformword.FlowFormID),
new SqlParameter("@IFW_Name", tbl_flowformword.IFW_Name),
new SqlParameter("@DealUser", tbl_flowformword.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_FlowFormWordById(Tbl_FlowFormWord tbl_flowformword)
{
string sql = "update [Tbl_FlowFormWord] set [FlowFormID]=@FlowFormID,[IFW_Name]=@IFW_Name,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_flowformword.ID),
new SqlParameter("@FlowFormID", tbl_flowformword.FlowFormID),
new SqlParameter("@IFW_Name", tbl_flowformword.IFW_Name),
new SqlParameter("@DealUser", tbl_flowformword.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
/// <summary>
///根据SQL语句获取实体
/// </summary>
private Tbl_FlowFormWord getTbl_FlowFormWordBySql(string sql)
{
Tbl_FlowFormWord tbl_flowformword = null;
DataSet ds = DBHelper.ExecuteDataset(this.connection, CommandType.Text, sql);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
tbl_flowformword = new Tbl_FlowFormWord();
foreach (DataRow dr in dt.Rows)
{
tbl_flowformword.ID = Convert.ToInt32(dr["ID"]);
tbl_flowformword.FlowFormID = Convert.ToInt32(dr["FlowFormID"]);
tbl_flowformword.IFW_Name = Convert.ToString(dr["IFW_Name"]);
tbl_flowformword.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_flowformword.DealUser = Convert.ToString(dr["DealUser"]);
tbl_flowformword.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_flowformword.AddDate = Convert.ToDateTime(dr["AddDate"]);
}
}
return(tbl_flowformword);
}
public static int AddTbl_FlowFormWord(Tbl_FlowFormWord tbl_flowformword)
{
WebCommon.Public.WriteLog("Ìí¼Ó¶ÌÓ" + tbl_flowformword.IFW_Name);
return(new Tbl_FlowFormWordService().AddTbl_FlowFormWord(tbl_flowformword));
}
