protected void btnAuthorization_Click(object sender, EventArgs e) { eFileAuthorization eFileAuthorization = new eFileAuthorization(); if (this.HdnYhdmList.Value != "") { if (this.RBSelect.SelectedValue == "0") { for (int i = 0; i < this.GVProjectFile.Rows.Count; i++) { CheckBox checkBox = (CheckBox)this.GVProjectFile.Rows[i].FindControl("CBRecordID"); if (checkBox.Checked) { eFileAuthorization.FileRecordID = Convert.ToInt32(this.GVProjectFile.DataKeys[i]["RecordID"].ToString()); eFileAuthorization.LeaderCode = this.Session["yhdm"].ToString(); eFileAuthorization.ReaderCodes = this.HdnYhdmList.Value.ToString(); this.efaa.Add(eFileAuthorization); } } return; } for (int j = 0; j < this.GVeFile.Rows.Count; j++) { CheckBox checkBox2 = (CheckBox)this.GVeFile.Rows[j].FindControl("CBRecordID"); if (checkBox2.Checked) { eFileAuthorization.FileRecordID = Convert.ToInt32(this.GVeFile.DataKeys[j]["RecordID"].ToString()); eFileAuthorization.LeaderCode = this.Session["yhdm"].ToString(); eFileAuthorization.ReaderCodes = this.HdnYhdmList.Value.ToString(); this.efaa.Add(eFileAuthorization); } } } }
public int Update(eFileAuthorization model) { StringBuilder builder = new StringBuilder(); builder.Append("update OA_eFile_Authorization set "); builder.Append("ReaderCodes='" + model.ReaderCodes + "'"); builder.Append(" where LeaderCode='" + model.LeaderCode + "'"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(eFileAuthorization model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into OA_eFile_Authorization("); builder.Append("LeaderCode,FileRecordID,ReaderCodes"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + model.LeaderCode + "',"); builder.Append(model.FileRecordID + ","); builder.Append("'" + model.ReaderCodes + "'"); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public eFileAuthorization GetModel(string LeaderCode) { StringBuilder builder = new StringBuilder(); builder.Append("select * "); builder.Append(" LeaderCode,FileRecordID,ReaderCodes "); builder.Append(" from OA_eFile_Authorization "); builder.Append(" where LeaderCode='" + LeaderCode + "'"); eFileAuthorization authorization = new eFileAuthorization(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); if (set.Tables[0].Rows.Count <= 0) { return(null); } authorization.LeaderCode = set.Tables[0].Rows[0]["LeaderCode"].ToString(); if (set.Tables[0].Rows[0]["FileRecordID"].ToString() != "") { authorization.FileRecordID = int.Parse(set.Tables[0].Rows[0]["FileRecordID"].ToString()); } authorization.ReaderCodes = set.Tables[0].Rows[0]["ReaderCodes"].ToString(); return(authorization); }