protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
// if (!IsPostBack)
{
BusinessHelp = new clsAllnew();
List <cls_order_info> AddreadCards = new List <cls_order_info>();
cls_order_info item = new cls_order_info();
item.PotNo = ((TextBox)(gvList.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim();
item.DDate = ((TextBox)(gvList.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();
item.AlCnt = ((TextBox)(gvList.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
item.Lsp = ((TextBox)(gvList.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim();
item.Djzsp = ((TextBox)(gvList.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim();
item.Djwd = ((TextBox)(gvList.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim();
item.Fzb = ((TextBox)(gvList.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim();
item.FeCnt = ((TextBox)(gvList.Rows[e.RowIndex].Cells[7].Controls[0])).Text.ToString().Trim();
item.SiCnt = ((TextBox)(gvList.Rows[e.RowIndex].Cells[8].Controls[0])).Text.ToString().Trim();
item.AlOCnt = ((TextBox)(gvList.Rows[e.RowIndex].Cells[9].Controls[0])).Text.ToString().Trim();
item.CaFCnt = ((TextBox)(gvList.Rows[e.RowIndex].Cells[10].Controls[0])).Text.ToString().Trim();
item.MgCnt = ((TextBox)(gvList.Rows[e.RowIndex].Cells[11].Controls[0])).Text.ToString().Trim();
item.LDYJ = ((TextBox)(gvList.Rows[e.RowIndex].Cells[12].Controls[0])).Text.ToString().Trim();
item.MLsp = ((TextBox)(gvList.Rows[e.RowIndex].Cells[13].Controls[0])).Text.ToString().Trim();
item.LPW = ((TextBox)(gvList.Rows[e.RowIndex].Cells[14].Controls[0])).Text.ToString().Trim();
item.Order_id = gvList.DataKeys[e.RowIndex].Values[0].ToString();
AddreadCards.Add(item);
BusinessHelp.changeCardServer(AddreadCards);
gvList.EditIndex = -1;
bind();
}
}
protected void btsearch_Click1(object sender, EventArgs e)
{
if (this.txrearchNAME.Text != "" && this.txtCompletionTime.Text != "")
{
BusinessHelp = new clsAllnew();
BusinessHelp.rev_servename = servename;
gohome();
readCards = new List <cls_order_info>();
int xuliehao = 0;
xuliehao = Select_xuhaolei(xuliehao);
string conditions = "select * from NewMeasueDataTable where ";//成功
conditions = SelectSql(xuliehao, conditions);
readCards = BusinessHelp.Readt_ItemServer(conditions);
if (readCards != null && readCards.Count > 1)
{
alterinfo = "本区信息已经数据库存在，无法添加！";
//readCards = new List<cls_order_info>();
}
else
{
xuliehao = Select_xuhaolei(xuliehao);
if (xuliehao > 0)
{
for (int i = 0; i < 38; i++)
{
cls_order_info item = new cls_order_info();
xuliehao++;
item.PotNo = xuliehao.ToString();
item.DDate = txtCompletionTime.Text.ToString();
readCards.Add(item);
}
btwrite_Click(null, EventArgs.Empty);
}
}
InitialSystemInfo();
}
}
public List <cls_order_info> Readt_ItemServer(string conditions)
{
try
{
OleDbConnection aConnection = new OleDbConnection(ConStr);
List <cls_order_info> ClaimReport_Server = new List <cls_order_info>();
if (aConnection.State == ConnectionState.Closed)
{
aConnection.Open();
}
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(conditions, aConnection);
OleDbCommandBuilder mybuilder = new OleDbCommandBuilder(myDataAdapter);
DataSet ds = new DataSet();
myDataAdapter.Fill(ds, "NewMeasueDataTable");
foreach (DataRow reader in ds.Tables["NewMeasueDataTable"].Rows)
{
cls_order_info item = new cls_order_info();
if (reader["Order_id"].ToString() != "")
{
item.Order_id = reader["Order_id"].ToString();
}
if (reader["PotNo"].ToString() != "")
{
item.PotNo = reader["PotNo"].ToString();
}
if (reader["DDate"].ToString() != "")
{
item.DDate = reader["DDate"].ToString();
item.DDate = clsCommHelp.objToDateTime1(reader["DDate"].ToString());
}
if (reader["AlCnt"].ToString() != "")
{
item.AlCnt = reader["AlCnt"].ToString();
}
if (reader["Lsp"].ToString() != "")
{
item.Lsp = reader["Lsp"].ToString();
}
if (reader["Djzsp"].ToString() != "")
{
item.Djzsp = reader["Djzsp"].ToString();
}
if (reader["Djwd"].ToString() != "")
{
item.Djwd = reader["Djwd"].ToString();
}
if (reader["Fzb"].ToString() != "")
{
item.Fzb = reader["Fzb"].ToString();
}
if (reader["FeCnt"].ToString() != "")
{
item.FeCnt = reader["FeCnt"].ToString();
}
if (reader["SiCnt"].ToString() != "")
{
item.SiCnt = reader["SiCnt"].ToString();
}
if (reader["AlOCnt"].ToString() != "")
{
item.AlOCnt = reader["AlOCnt"].ToString();
}
if (reader["CaFCnt"].ToString() != "")
{
item.CaFCnt = reader["CaFCnt"].ToString();
}
if (reader["MgCnt"].ToString() != "")
{
item.MgCnt = reader["MgCnt"].ToString();
}
if (reader["LDYJ"].ToString() != "")
{
item.LDYJ = reader["LDYJ"].ToString();
}
if (reader["MLsp"].ToString() != "")
{
item.MLsp = reader["MLsp"].ToString();
}
if (reader["LPW"].ToString() != "")
{
item.LPW = reader["LPW"].ToString();
}
ClaimReport_Server.Add(item);
}
return(ClaimReport_Server);
}
catch (Exception ex)
{
HttpContext.Current.Response.Redirect("~/ErrorPage/ErrorPage.aspx?Error=" + "网络访问较慢或网络不通无法访问 ：" + ex.ToString());
// inputlog(ex.Message + "//" + ex.Source + "//" + ex.StackTrace);
throw ex;
}
}
