protected void btnDeleteChild_Click(object sender, EventArgs e) { int[] intRowindexarray = childGrid.SelectedRowIndexArray; if (intRowindexarray.Length > 0) { pp_contract_content pcc = new pp_contract_content(); object[] keys = childGrid.DataKeys[intRowindexarray[0]]; string strID = keys[0].ToString(); string strpid = keys[1].ToString(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("ID", " cast(ID as varchar(36))='" + strID + "' "); int intresult = pcc.deletebycondition("pp_contract_content", dic); BindchildGrid(strpid); Alert alert = new Alert(); if (intresult > 0) { alert.Icon = Icon.Information; alert.Message = "成功移除数据"; } else { alert.MessageBoxIcon = MessageBoxIcon.Error; alert.Message = "数据移除失败"; } alert.Show(); } }
private void BindchildGrid(string strpid) { pp_contract_content pcc = new pp_contract_content(); System.Data.DataTable dt = pcc.getBindDataAsdt(strpid); editID.Text = strpid; childGrid.DataSource = dt; childGrid.DataBind(); }
private void initchildinfo(string strID) { pp_contract_content pcc = new pp_contract_content(); System.Data.DataTable dt = pcc.getEditdata(strID); DataRow r = dt.Rows[0]; editchildID.Text = strID; conpdname.Text = r["conpdname"].ToString().Trim(); conpdmodel.Text = r["conpdmodel"].ToString().Trim(); conpdnumber.Text = r["conpdnumber"].ToString().Trim(); conpduint.SelectedValue = r["conpduint"].ToString().Trim(); conpdprice.Text = r["conpdprice"].ToString().Trim(); deliveryaddress.Text = r["deliveryaddress"].ToString().Trim(); deliverydate.SelectedDate = DateTime.Parse(r["deliverydate"].ToString().Trim()); }
protected void btnSaveChild_Click(object sender, EventArgs e) { string strID = editchildID.Text.ToString().Trim(); string strpid = editID.Text.ToString().Trim(); Dictionary <string, string> dic = initchildDatadic(strpid); pp_contract_content pcc = new pp_contract_content(); int intresult = 0; if (strID == "") { dic.Add("ID", Guid.NewGuid().ToString()); intresult = pcc.add(dic, "pp_contract_content"); } else { intresult = pcc.update(dic, "pp_contract_content", "ID", strID); } BindchildGrid(strpid); Alert alert = new Alert(); if (intresult == 1) { alert.Icon = Icon.Information; alert.Message = "数据保存成功"; } else { alert.MessageBoxIcon = MessageBoxIcon.Error; alert.Message = "数据保存失败"; } alert.Show(); }