public int Update(OAFileLend model) { StringBuilder builder = new StringBuilder(); builder.Append("update OA_File_Lend set "); builder.Append("LendDate='" + model.LendDate + "',"); builder.Append("PlanReturnDate='" + model.PlanReturnDate + "',"); builder.Append("ReturnApplyDate='" + model.ReturnApplyDate + "',"); builder.Append("ReturnDate='" + model.ReturnDate + "',"); builder.Append("LendState='" + model.LendState + "'"); builder.Append(" where RecordID=" + model.RecordID); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
protected void GVLend_RowDataBound(object sender, GridViewRowEventArgs e) { switch (e.Row.RowType) { case DataControlRowType.Header: case DataControlRowType.DataRow: e.Row.Cells[11].Style["display"] = "none"; break; } if (e.Row.RowIndex > -1) { OAFileLend oAFileLend = (OAFileLend)e.Row.DataItem; e.Row.Attributes["onmouseover"] = "OnMouseOverRecord(this);"; e.Row.Attributes["onclick"] = "OnRecord(this);FileLendClickRow('" + oAFileLend.RecordID.ToString() + "');"; HtmlInputCheckBox htmlInputCheckBox = (HtmlInputCheckBox)e.Row.Cells[0].Controls[1]; htmlInputCheckBox.Value = oAFileLend.RecordID.ToString(); htmlInputCheckBox.Attributes["onclick"] = "CheckLendFileCode(this);"; e.Row.Cells[1].Text = oAFileLend.FileCatalog.FileCode; e.Row.Cells[2].Text = oAFileLend.FileCatalog.FileName; e.Row.Cells[3].Text = oAFileLend.FileCatalog.Volume.ToString(); e.Row.Cells[4].Text = oAFileLend.FileCatalog.FileNumber.ToString(); e.Row.Cells[5].Text = oAFileLend.FileCatalog.BoxNumber.ToString(); e.Row.Cells[6].Text = oAFileLend.FileCatalog.SavePlace; e.Row.Cells[7].Text = oAFileLend.FileCatalog.PrjName; e.Row.Cells[8].Text = oAFileLend.FileCatalog.Principal; switch (oAFileLend.FileCatalog.SecretLevel) { case 1: e.Row.Cells[9].Text = "密秘"; break; case 2: e.Row.Cells[9].Text = "机密"; break; case 3: e.Row.Cells[9].Text = "绝密"; break; } TextBox textBox = (TextBox)e.Row.Cells[10].Controls[1]; textBox.Attributes["onchange"] = "javascript:if(!isDate(this)) return false;"; textBox.Text = oAFileLend.PlanReturnDate.ToShortDateString(); textBox.ToolTip = "输入档案借阅日期!"; } }
public OAFileLend GetModel(int RecordID) { StringBuilder builder = new StringBuilder(); builder.Append("select * "); builder.Append(" RecordID,BorrowMan,FileRecordID,LendDate,PlanReturnDate,ReturnApplyDate,ReturnDate,LendState "); builder.Append(" from OA_File_Lend "); builder.Append(" where RecordID=" + RecordID); OAFileLend lend = new OAFileLend(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); if (set.Tables[0].Rows.Count <= 0) { return(null); } if (set.Tables[0].Rows[0]["RecordID"].ToString() != "") { lend.RecordID = int.Parse(set.Tables[0].Rows[0]["RecordID"].ToString()); } lend.BorrowMan = set.Tables[0].Rows[0]["BorrowMan"].ToString(); if (set.Tables[0].Rows[0]["FileRecordID"].ToString() != "") { lend.FileRecordID = int.Parse(set.Tables[0].Rows[0]["FileRecordID"].ToString()); } if (set.Tables[0].Rows[0]["LendDate"].ToString() != "") { lend.LendDate = DateTime.Parse(set.Tables[0].Rows[0]["LendDate"].ToString()); } if (set.Tables[0].Rows[0]["PlanReturnDate"].ToString() != "") { lend.PlanReturnDate = DateTime.Parse(set.Tables[0].Rows[0]["PlanReturnDate"].ToString()); } if (set.Tables[0].Rows[0]["ReturnApplyDate"].ToString() != "") { lend.ReturnApplyDate = DateTime.Parse(set.Tables[0].Rows[0]["ReturnApplyDate"].ToString()); } if (set.Tables[0].Rows[0]["ReturnDate"].ToString() != "") { lend.ReturnDate = DateTime.Parse(set.Tables[0].Rows[0]["ReturnDate"].ToString()); } lend.LendState = set.Tables[0].Rows[0]["LendState"].ToString(); return(lend); }
public int Add(OAFileLend model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into OA_File_Lend("); builder.Append("RecordID,BorrowMan,FileRecordID,LendDate,PlanReturnDate,ReturnApplyDate,ReturnDate,LendState"); builder.Append(")"); builder.Append(" values ("); builder.Append(model.RecordID + ","); builder.Append("'" + model.BorrowMan + "',"); builder.Append(model.FileRecordID + ","); builder.Append("'" + model.LendDate + "',"); builder.Append("'" + model.PlanReturnDate + "',"); builder.Append("'" + model.ReturnApplyDate + "',"); builder.Append("'" + model.ReturnDate + "',"); builder.Append("'" + model.LendState + "'"); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }