public static String AddReconciliation(string Clearing, string ReconciliaT, string ReconciliaPer, string Remarks
, string Pspnum, string hospitalSelect1, string STime, string ETime)
{
string[] arr = null;
RecipeModel rm = new RecipeModel();
DataTable sdr1 = rm.AccountStatementInfo(Pspnum, STime, ETime, Convert.ToInt32(hospitalSelect1));
arr = new string[sdr1.Rows.Count];
for (var i = 0; i < sdr1.Rows.Count; i++)
{
arr[i] = sdr1.Rows[i]["id"].ToString();
}
int sdr = 0;
// string[] strRows1Id = strRowIDs.Split(',');
DataBaseLayer db = new DataBaseLayer();
// now：生成对账单时间
System.DateTime now = new System.DateTime();
now = System.DateTime.Now;
string n = now.ToString();
// ReconciliaT:对账时间
string current = now.ToString("yyyyMMddhhmmss");
string str = "select id from Clearingparty where ClearPName = '" + Clearing + "'";
SqlDataReader sr = db.get_Reader(str);
if (sr.Read())
{
for (int i = 0; i < arr.Length; i++)
{
string Retime = sr["id"].ToString() + current;
ClearingpartyHandler ch = new ClearingpartyHandler();
sdr = ch.AddReconciliation1(Clearing, ReconciliaT, ReconciliaPer, Remarks, arr[i], n, Retime);
}
}
return("");
}
} //提供数据的方法
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid1DataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
RecipeModel rm = new RecipeModel();
string Pspnum = "";
if (p.extParam.ContainsKey("Pspnum"))
{
Pspnum = p.extParam["Pspnum"];
}
string STime = "";
if (p.extParam.ContainsKey("STime"))
{
STime = p.extParam["STime"];
}
string ETime = "";
if (p.extParam.ContainsKey("ETime"))
{
ETime = p.extParam["ETime"];
}
string hospitalId = "0";
if (p.extParam.ContainsKey("hospitalId"))
{
hospitalId = p.extParam["hospitalId"];
}
result.table = rm.AccountStatementInfo(Pspnum, STime, ETime, Convert.ToInt32(hospitalId));
dotNetFlexGrid.FieldFormatorHandle proc3 = delegate(DataRow dr)
{
int b = Convert.ToInt32(dr["decscheme"].ToString());
if (b == 1)
{
return("微压（密闭）解表（15min）");
}
else if (b == 2)
{
return("微压（密闭）汤药（15min）");
}
else if (b == 3)
{
return("微压（密闭）补药（15min）");
}
else if (b == 4)
{
return("常压解表（10min，10min）");
}
else if (b == 5)
{
return("常压汤药（20min，15min）");
}
else if (b == 6)
{
return("常压补药（25min，20min）");
}
else if (b == 20)
{
return("先煎解表（10min，10min，10min）");
}
else if (b == 21)
{
return("先煎汤药（10min，20min，15min）");
}
else if (b == 22)
{
return("先煎补药（10min，25min，20min）");
}
else if (b == 36)
{
return("后下解表（10min（3：7），10min）");
}
else if (b == 37)
{
return("后下汤药（20min（13：7），15min）");
}
else if (b == 38)
{
return("后下补药（25min（18：7），20min）");
}
else if (b == 81)
{
return("微压自定义");
}
else if (b == 82)
{
return("常压自定义");
}
else if (b == 83)
{
return("先煎自定义");
}
else
{
return("后下自定义");
}
};
result.FieldFormator.Register("decscheme", proc3);
dotNetFlexGrid.FieldFormatorHandle proc4 = delegate(DataRow dr)
{
int a = Convert.ToInt32(dr["decmothed"].ToString());
if (a == 1)
{
return("先煎");
}
else if (a == 2)
{
return("后下");
}
else
{
return("加糖加蜜");
}
};
result.FieldFormator.Register("decmothed", proc4);
dotNetFlexGrid.FieldFormatorHandle proc6 = delegate(DataRow dr)
{
int a = Convert.ToInt32(dr["takeway"].ToString());
if (a == 1)
{
return("水煎餐后");
}
else
{
return("");
}
};
result.FieldFormator.Register("takeway", proc6);
dotNetFlexGrid.FieldFormatorHandle proc5 = delegate(DataRow dr)
{
int a = Convert.ToInt32(dr["dtbtype"].ToString());
if (a == 1)
{
return("顺丰");
}
else if (a == 2)
{
return("圆通");
}
else
{
return("中通");
}
};
result.FieldFormator.Register("dtbtype", proc5);
return(result);
}
//导出数据
protected void Button1_Click(object sender, EventArgs e)
{
string[] arr = null;
string strRowIDs = "";
if (Request.QueryString["Pspnum"] != null || Request.QueryString["hospitalSelect"] != null || Request.QueryString["STime"] != null || Request.QueryString["ETime"] != null)
{
RecipeModel rm = new RecipeModel();
string Pspnum = Request.QueryString["Pspnum"];
string hospitalSelect = Request.QueryString["id"];
string STime = Request.QueryString["STime"];
string ETime = Request.QueryString["ETime"];
string Pspnum1 = Request.QueryString["Pspnum"].ToString();
string hospitalSelect1 = Request.QueryString["hospitalSelect"].ToString();
string STime1 = Request.QueryString["STime"].ToString();
string ETime1 = Request.QueryString["ETime"].ToString();
DataTable sdr1 = rm.AccountStatementInfo(Pspnum, STime, ETime, Convert.ToInt32(hospitalSelect1));
arr = new string[sdr1.Rows.Count];
int a = sdr1.Rows.Count;
for (var i = 0; i < sdr1.Rows.Count; i++)
{
arr[i] = sdr1.Rows[i]["id"].ToString();
strRowIDs = arr[i].ToString();
}
int sdr = 0;
string Clearing = Clearing1.Value;
string ReconciliaT = ReconciliaT1.Value;
string ReconciliaPer = ReconciliaPer1.Value;
string Remarks = RemarksA.Value;
// string[] strRows1Id = strRowIDs.Split(',');
DataBaseLayer db = new DataBaseLayer();
// now：生成对账单时间
System.DateTime now = new System.DateTime();
now = System.DateTime.Now;
string n = now.ToString();
// ReconciliaT:对账时间
string current = now.ToString("yyyyMMddhhmmss");
string str = "select id from Clearingparty where ClearPName = '" + Clearing + "'";
SqlDataReader sr = db.get_Reader(str);
if (sr.Read())
{
for (int i = 0; i < arr.Length; i++)
{
string Retime = sr["id"].ToString() + current;
ClearingpartyHandler ch = new ClearingpartyHandler();
sdr = ch.AddReconciliation1(Clearing, ReconciliaT, ReconciliaPer, Remarks, arr[i], n, Retime);
}
}
// Response.Write("<script type='text/javascript'>refurbishFlexGridRecipe();</script>");
/* DataTable dt = null;
*
* ClearingpartyHandler ch2 = new ClearingpartyHandler();
*
* dt = ch2.SearchInfoabc(arr);
*
* CreateExcel(dt, "application/ms-excel", "excel");*/
}
}