public List <WorkFlow> LoadWorkFlows()
{
string sql = @"Select
[WorkFlowID]
,[WorkFlowCode]
,[WorkFlowName]
,[ImageUrl]
,[Remark]
,[SortNo]
,[Created]
,[CreatedBy]
From [BE_WorkFlow] With(NoLock)";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
List <WorkFlow> ret = new List <WorkFlow>();
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
WorkFlow iret = new WorkFlow();
if (!Convert.IsDBNull(dr["WorkFlowID"]))
{
iret.WorkFlowID = (Guid)dr["WorkFlowID"];
}
if (!Convert.IsDBNull(dr["WorkFlowCode"]))
{
iret.WorkFlowCode = (string)dr["WorkFlowCode"];
}
if (!Convert.IsDBNull(dr["WorkFlowName"]))
{
iret.WorkFlowName = (string)dr["WorkFlowName"];
}
if (!Convert.IsDBNull(dr["ImageUrl"]))
{
iret.ImageUrl = (string)dr["ImageUrl"];
}
if (!Convert.IsDBNull(dr["Remark"]))
{
iret.Remark = (string)dr["Remark"];
}
if (!Convert.IsDBNull(dr["SortNo"]))
{
iret.SortNo = (int)dr["SortNo"];
}
if (!Convert.IsDBNull(dr["Created"]))
{
iret.Created = (DateTime)dr["Created"];
}
if (!Convert.IsDBNull(dr["CreatedBy"]))
{
iret.CreatedBy = (string)dr["CreatedBy"];
}
ret.Add(iret);
}
}
finally
{
dr.Close();
}
return(ret);
}
public int LoadWorkFlow(WorkFlow obj)
{
string sql = @"Select
[WorkFlowID]
,[WorkFlowCode]
,[WorkFlowName]
,[ImageUrl]
,[Remark]
,[SortNo]
,[Created]
,[CreatedBy]
From [BE_WorkFlow] With(NoLock) Where WorkFlowID=@WorkFlowID";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pWorkFlowID = new SqlParameter("WorkFlowID", Convert2DBnull(obj.WorkFlowID));
pWorkFlowID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pWorkFlowID);
int ret = 0;
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
if (!Convert.IsDBNull(dr["WorkFlowID"]))
{
obj.WorkFlowID = (Guid)dr["WorkFlowID"];
}
if (!Convert.IsDBNull(dr["WorkFlowCode"]))
{
obj.WorkFlowCode = (string)dr["WorkFlowCode"];
}
if (!Convert.IsDBNull(dr["WorkFlowName"]))
{
obj.WorkFlowName = (string)dr["WorkFlowName"];
}
if (!Convert.IsDBNull(dr["ImageUrl"]))
{
obj.ImageUrl = (string)dr["ImageUrl"];
}
if (!Convert.IsDBNull(dr["Remark"]))
{
obj.Remark = (string)dr["Remark"];
}
if (!Convert.IsDBNull(dr["SortNo"]))
{
obj.SortNo = (int)dr["SortNo"];
}
if (!Convert.IsDBNull(dr["Created"]))
{
obj.Created = (DateTime)dr["Created"];
}
if (!Convert.IsDBNull(dr["CreatedBy"]))
{
obj.CreatedBy = (string)dr["CreatedBy"];
}
ret += 1;
}
}
finally
{
dr.Close();
}
return(ret);
}
public int InsertWorkFlow(WorkFlow obj)
{
string sql = @"Insert Into [BE_WorkFlow](
[WorkFlowID]
,[WorkFlowCode]
,[WorkFlowName]
,[ImageUrl]
,[Remark]
,[SortNo]
,[Created]
,[CreatedBy]
)Values (
@WorkFlowID
,@WorkFlowCode
,@WorkFlowName
,@ImageUrl
,@Remark
,@SortNo
,@Created
,@CreatedBy
)";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pWorkFlowID = new SqlParameter("WorkFlowID", Convert2DBnull(obj.WorkFlowID));
pWorkFlowID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pWorkFlowID);
SqlParameter pWorkFlowCode = new SqlParameter("WorkFlowCode", Convert2DBnull(obj.WorkFlowCode));
pWorkFlowCode.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pWorkFlowCode);
SqlParameter pWorkFlowName = new SqlParameter("WorkFlowName", Convert2DBnull(obj.WorkFlowName));
pWorkFlowName.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pWorkFlowName);
SqlParameter pImageUrl = new SqlParameter("ImageUrl", Convert2DBnull(obj.ImageUrl));
pImageUrl.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pImageUrl);
SqlParameter pRemark = new SqlParameter("Remark", Convert2DBnull(obj.Remark));
pRemark.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pRemark);
SqlParameter pSortNo = new SqlParameter("SortNo", Convert2DBnull(obj.SortNo));
pSortNo.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(pSortNo);
SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created));
pCreated.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pCreated);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy));
pCreatedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCreatedBy);
return(cmd.ExecuteNonQuery());
}
