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()); }