private void btnSave_Click(object sender, EventArgs e) { PermissionGroupEntity group = new PermissionGroupEntity(); group.OID = hdfGroupID.Value; group.CUSER = AppCenter.CurrentPersonAccount; group.MUSER = AppCenter.CurrentPersonAccount; group.GroupCode = txtGroupCode.Text.Trim(); group.GroupName = txtGroupName.Text.Trim(); group.GroupStatus = Convert.ToInt32(drpGroupStatus.SelectedValue); group.MEMO = txtGroupMemo.Text.Trim(); bool retValue = true; if (string.IsNullOrEmpty(group.OID)) { group.OID = Guid.NewGuid().ToString(); retValue = new PermissionGroupController().InsertGroup(group); } else { retValue = new PermissionGroupController().UpdateGroup(group); } if (retValue) { hdfFlag.Value = "1"; base.ShowMessage(CommonMessage.SaveSuccess); } else { base.ShowMessage(CommonMessage.SaveFailed); } }
public bool InsertGroup(PermissionGroupEntity group) { if (group != null) { string strSQL = @" INSERT INTO dbo.TBLPermissionGroup( oid , groupcode , groupname , groupstatus ,memo, cuser , cdate , muser , mdate , addition1 , addition2 ) VALUES ( @OID , @GroupCode , @GroupName , @GroupStatus,@Memo, @Cuser , GETDATE(), @Muser,GETDATE(),NULL, NULL) "; string[] paramNames = new string[7]; object[] paramValues = new object[7]; paramNames[0] = "OID"; paramNames[1] = "GroupCode"; paramNames[2] = "GroupName"; paramNames[3] = "GroupStatus"; paramNames[4] = "Memo"; paramNames[5] = "Cuser"; paramNames[6] = "Muser"; paramValues[0] = group.OID; paramValues[1] = group.GroupCode; paramValues[2] = group.GroupName; paramValues[3] = group.GroupStatus; paramValues[4] = group.MEMO; paramValues[5] = group.CUSER; paramValues[6] = group.MUSER; SqlDBBroker broker = new SqlDBBroker(); try { broker.Open(); broker.BeginTrans(); broker.ExecuteNonQuery(strSQL, CommandType.Text, paramNames, paramValues); broker.CommitTrans(); } catch { broker.RollbackTrans(); return false; } finally { broker.Close(); } } return true; }
public PermissionGroupEntity GetGroupInfo(string personID) { PermissionGroupEntity pe = new PermissionGroupEntity(); string strSql = @" SELECT * FROM TBLPermissionGroup WHERE oid=@OID "; string[] paramName = new string[1]; object[] paramValue = new object[1]; paramName[0] = "OID"; paramValue[0] = personID; SqlDBBroker broker = new SqlDBBroker(); broker.Open(); DataSet dst = broker.ExecuteDataset(strSql, CommandType.Text, paramName, paramValue); broker.Close(); if (dst != null && dst.Tables[0] != null && dst.Tables[0].Rows.Count > 0) { return this.DataRow2Group(dst.Tables[0].Rows[0]); } else { return null; } }
private PermissionGroupEntity DataRow2Group(DataRow dr) { PermissionGroupEntity group = new PermissionGroupEntity(); if (dr != null) { group.OID = Convert.ToString(dr["oid"]); group.GroupCode = Convert.ToString(dr["groupcode"]); group.GroupName = Convert.ToString(dr["groupname"]); group.GroupStatus = Convert.ToInt32(dr["groupstatus"]); group.MEMO = Convert.ToString(dr["memo"]); } return group; }
public bool UpdateGroup(PermissionGroupEntity group) { if (group != null) { string strSQL = @" UPDATE TBLPermissionGroup SET groupcode=@GroupCode,groupname=@GroupName,groupstatus=@GroupStatus, memo=@Memo,muser=@Muser,mdate=GETDATE() WHERE oid=@OID "; string[] paramNames = new string[6]; object[] paramValues = new object[6]; paramNames[0] = "OID"; paramNames[1] = "GroupCode"; paramNames[2] = "GroupName"; paramNames[3] = "GroupStatus"; paramNames[4] = "Memo"; paramNames[5] = "Muser"; paramValues[0] = group.OID; paramValues[1] = group.GroupCode; paramValues[2] = group.GroupName; paramValues[3] = group.GroupStatus; paramValues[4] = group.MEMO; paramValues[5] = group.MUSER; SqlDBBroker broker = new SqlDBBroker(); try { broker.Open(); broker.BeginTrans(); broker.ExecuteNonQuery(strSQL, CommandType.Text, paramNames, paramValues); broker.CommitTrans(); } catch { broker.RollbackTrans(); return false; } finally { broker.Close(); } } return true; }