public List<string> CheckDB_AfterGet(PatientDto patient)
{
var errorList = new List<string>();
CommonFun f = new CommonFun();
errorList.AddRange(f.Check_MainDataInDB(patient.IdGlobal, patient));
if (patient.Job != null)
errorList.AddRange(f.Check_JobInDB(patient.IdGlobal, patient.Job));
if (patient.BirthPlace != null)
errorList.AddRange(f.Check_BirthPlaceInDB(patient.IdGlobal, patient.BirthPlace));
if (patient.Contacts != null)
{
foreach (ContactDto contact in patient.Contacts)
errorList.AddRange(f.Check_ContactInDB(patient.IdGlobal, contact));
}
if (patient.Documents != null)
{
foreach (DocumentDto document in patient.Documents)
errorList.AddRange(f.Check_DocumentInDB(patient.IdGlobal, document));
}
if (patient.Addresses != null)
{
foreach (AddressDto address in patient.Addresses)
errorList.AddRange(f.Check_AddressInDB(patient.IdGlobal, address));
}
if (patient.Privilege != null)
errorList.AddRange(f.Check_PrivilegeInDB(patient.IdGlobal, patient.Privilege));
return errorList;
}
private void bindGrid()
{
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, grvFPJL, UCPaging1, pal_NoData);
if (pal_NoData.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo(); //分页控件中要显示的控件
}
//CheckUser(ControlFinder);
}
private void bindGrid()
{
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, pc_purinform_repeater, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo(); //分页控件中要显示的控件
}
//CheckUser(ControlFinder);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btninsert_Click(object sender, EventArgs e)
{
DataTable dt = this.GetDataFromGrid(false);
int a = CommonFun.ComTryInt(txtNum.Text.Trim());
for (int i = 0; i < a; i++)
{
DataRow newRow = dt.NewRow();
dt.Rows.Add(newRow);
}
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
txtNum.Text = "";
}
protected void bindData()
{
pager.PageIndex = UCPaging1.CurrentPage;
System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamGroupBy(pager);
CommonFun.Paging(dt, Purordertotal_list_Repeater, UCPaging1, NoDataPane);
if (NoDataPane.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
//clearData();
}
//导入更新年假信息
private void drupdateysynianj()
{
List <string> listupdate = new List <string>();
string sqlupdate = "";
string sqlgetdata = "select KQ_ST_ID,sum(KQ_NIANX) as KQ_NIANXnew from OM_KQTJ where KQ_DATE='" + tb_yearmonth.Text.ToString().Trim() + "' and KQ_TYPE='1' group by KQ_ST_ID";
System.Data.DataTable dtgetdata = DBCallCommon.GetDTUsingSqlText(sqlgetdata);
if (dtgetdata.Rows.Count > 0)
{
for (int i = 0; i < dtgetdata.Rows.Count; i++)
{
sqlupdate = "update OM_NianJiaTJ set NJ_YSY=NJ_YSY+" + CommonFun.ComTryDecimal(dtgetdata.Rows[i]["KQ_NIANXnew"].ToString().Trim()) + " where NJ_ST_ID='" + dtgetdata.Rows[i]["KQ_ST_ID"] + "'";
listupdate.Add(sqlupdate);
}
}
DBCallCommon.ExecuteTrans(listupdate);
}
private void bindGrid()
{
pager.PageIndex = UCPaging1.CurrentPage;
System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, rptTBCS_CUSUPINFO, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
Panel1.Visible = false;
}
else
{
UCPaging1.Visible = true;
Panel1.Visible = true;
UCPaging1.InitPageInfo(); //分页控件中要显示的控件
}
}
protected void GetBoundData3()
{
InitPager3();
pager3.PageIndex = UCPaging3.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager3);
CommonFun.Paging(dt, gridview3, UCPaging3, NoDataPanel3);
if (NoDataPanel3.Visible)
{
UCPaging3.Visible = false;
}
else
{
UCPaging3.Visible = true;
UCPaging3.InitPageInfo();
}
}
private void bindrpt()
{
InitPager();
pager_org.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org);
CommonFun.Paging(dt, rptGZQD, UCPaging1, palNoData1);
if (palNoData1.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
protected void GetBoundData()
{
InitPager();
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, GridView1, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
private void bindGrid()
{
InitPager();
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, Repeater1, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
protected void ddl_jy_changed(object sender, EventArgs e)
{
//加油费
double jy = 0;
string sql = "select MONEY FROM TBOM_CAROIL WHERE RQ LIKE '%" + ddl_jy.SelectedValue.ToString() + "%' and CARNUM='" + id + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
jy += CommonFun.ComTryDouble(dt.Rows[i]["MONEY"].ToString());
}
}
lbl_jy.Text = jy.ToString();
}
private void bindGrid()
{
pager.PageIndex = UCPaging.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager);
CommonFun.Paging(dt, GridView1, UCPaging, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging.Visible = false;
}
else
{
UCPaging.Visible = true;
UCPaging.InitPageInfo(); //分页控件中要显示的控件
}
}
/// <summary>
/// 使用页面查询对象更新GridView的数据和页码控件的数据
/// </summary>
protected void GetTechRequireData()
{
//将当前页数传递给页面查询对象
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, GridView1, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
private void bindGrid()
{
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, GridView1, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
CheckUser(ControlFinder);
}
/// <summary>
/// 获取一页的所有物品
/// </summary>
/// <param name="itemStr"></param>
/// <returns></returns>
public List <BaseItemInfo> GetOnePageItems(string itemStr)
{
List <BaseItemInfo> items = new List <BaseItemInfo>();
itemStr = itemStr.Replace('\n', ' ');
itemStr = itemStr.Replace('\t', ' ');
MatchCollection ms = CommonFun.GetValues(itemStr, "<div class=\"tkprolistbox\">", "修改");
foreach (Match m in ms)
{
ItemInfo item = GetOneItem(m.Value);
items.Add(item);
}
return(items);
}
protected void bindData()
{
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParamGroupBy(pager);
CommonFun.Paging(dt, Repeater1, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
//clearData();
}
//<div class="span2" id="mall_price67369">20.99</div>
//<div class="span2" id="market_price67369">21.00</div>
//<div class="span1 money-box throughtmoney">
//<div class="money" id="stock67369">115</div>
//<div><span>商品规格：</span>3g*15袋/盒</div>
//<div><span>批准文号：</span>国药准字H19990307</div>
//<div><span>生产厂家：</span>先声药业有限公司</div>
public ItemInfo GetOneItem(string itemStr)
{
ItemInfo item = new ItemInfo();
item.Name = CommonFun.GetValue(itemStr, "; ", "</a>");
item.ID = CommonFun.GetValue(itemStr, "<span>批准文号：</span>", "</p>");
item.Format = CommonFun.GetValue(itemStr, "<span>商品规格：</span>", "</p>");
item.Created = CommonFun.GetValue(itemStr, "<span>生产企业：</span>", "</p>");
item.ViewCount = CommonFun.GetValue(itemStr, "value=\"", "\">");
item.Inventory = CommonFun.GetValue(itemStr, "stockEd=\"", "\"");
item.Type = CommonFun.GetValue(itemStr, "promotionEd=\"", "\"");
string priceStr = CommonFun.GetValue(itemStr, "priceEd=\"", "\"");
item.PlatformPrice = Convert.ToDecimal(priceStr);
return(item);
}
protected void GetBoundData()
{
InitPager();
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, Purordertotal_list_Repeater, UCPaging1, NoDataPane);
if (NoDataPane.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
private void bindGrid()
{
pager.PageIndex = UCPaging1.CurrentPage;
System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamGroupBy(pager);
CommonFun.Paging(dt, GridView1, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string wherestr = " where 1=1";
if (CBOrg.Checked)
{
string selectorgid = DropDownList1.SelectedValue;
if (selectorgid == "1")
{
wherestr += " and kaoqin.OrganizeID in (select OrganizeID from Organize)";
}
else
{
wherestr += " and kaoqin.OrganizeID in (select OrganizeID from Organize where organizeid=" + selectorgid + " or parentid=" + selectorgid + ")";
}
}
else
{
wherestr += " and kaoqin.OrganizeID in (select OrganizeID from Organize where organizeid=" + Session["OrganizeID"].ToString() + " or parentid=" + Session["OrganizeID"].ToString() + ")";
}
if (CBDateTime.Checked)
{
if (StartDate.Text.Length == 0 || EndDate.Text.Length == 0)
{
CommonFun.Show(this, "请选择起止日期!");
return;
}
else
{
wherestr += " and kaoqin.KaoqinDate between '" + StartDate.Text + "' and '" + EndDate.Text + "'";
}
}
string selectstr = @"SELECT Organize.OrgName, kaoqin.KaoqinDate, kaoqin.Rs, kaoqin.remark, kaoqin.KaoqinID,
kaoqin.OrganizeID FROM kaoqin INNER JOIN Organize ON kaoqin.OrganizeID = Organize.OrganizeID " + wherestr;
Session["selectstr"] = selectstr;
//DbHelper db = new DbHelper();
//DbCommand cmd = db.GetSqlStringCommond(selectstr);
int recount = BindData();
LPage.Visible = true;
LPage.Text = "共" + recount.ToString() + "条记录，每页" + GridView1.PageSize.ToString() + "条记录";
}
/// <summary>
/// 获取所有在售物品
/// </summary>
/// <returns></returns>
public bool ReadeAllSellingItme()
{
GetWebPageDate.Http.HttpRequest http = new GetWebPageDate.Http.HttpRequest();
http.CookieContainer = Login();
// http.Cookie = "acw_tc=AQAAAMj+8lkEeQUA3eT4OlKCFpqJmk95; Hm_lvt_3ad2c5e8712b25159b989a93a9927632=1510644101; Hm_lpvt_3ad2c5e8712b25159b989a93a9927632=1510645266; PHPSESSID=dem5mqnu6bfibviglvjh9d4ud1; Qs_lvt_150743=1509785002%2C1510643909%2C1510747212; nTalk_CACHE_DATA={uid:kf_9335_ISME9754_guestTEMP1758-0E75-6A,tid:1510643909116098}; NTKF_T2D_CLIENTID=guestTEMP1758-0E75-6A74-9EB9-8632DF7CEB19; Qs_pv_150743=2882295116553261000%2C1172614365052146400%2C979891720064693100%2C1505959923634373400%2C662315226244183900; Hm_lvt_ed70f863f631ecaac146592025767ed8=1509785002,1510643909; Hm_lpvt_ed70f863f631ecaac146592025767ed8=1510747235; sellerCooke=think%3A%7B%22sellerName%22%3A%22hankang%22%2C%22sellerStoreName%22%3A%22%25E9%2595%25BF%25E6%25B2%2599%25E5%258E%25BF001%25E5%25BA%2597%22%7D; Hm_lvt_7203bc79de07054ef3770e27e8ca9068=1509780503,1509934350,1510060776,1510543588; Hm_lpvt_7203bc79de07054ef3770e27e8ca9068=1510747284";
string content = http.HttpGet("https://admin.tkyfw.com/Goods/throughAudit?/Goods/throughAudit=&status=1&state=1");
string itemStr = CommonFun.GetValue(content, "<form name=\"form\" method=\"post\">", "</form>");
UpdateAllSellingItemPrice(itemStr, http);
string pageStr = CommonFun.GetValue(content, "下一页", "><span>末页</span>");
pageStr = CommonFun.GetValue(pageStr, "&p=", "\"");
pageStr = pageStr.Substring(pageStr.LastIndexOf("=") + 1);
int totalPage = 0;
if (!string.IsNullOrEmpty(pageStr))
{
totalPage = Convert.ToInt32(pageStr);
}
for (int i = 2; i <= totalPage; i++)
{
if (i % 200 == 0)
{
http.CookieContainer = Login();
}
content = http.HttpGet("https://admin.tkyfw.com/Goods/throughAudit?/Goods/throughAudit=&status=1&state=1&p=" + i);
itemStr = CommonFun.GetValue(content, "<form name=\"form\" method=\"post\">", "</form>");
UpdateAllSellingItemPrice(itemStr, http);
Console.WriteLine("{2}:totalPage:{0}, curPage:{1}", totalPage, i, DateTime.Now);
}
return(true);
}
/// <summary>
/// 刷新地图设置
/// </summary>
private void RefreshMapSet()
{
this.mapImage.Map.Layers.Clear();
listView_Layr.Items.Clear();
com_MainMap.Items.Clear();
MapLayerRow = null;
//加载地图图层
DataRow[] rows = DB_Service.MainDataSet.Tables["LayerTable"].Select("DataSourceType = 2");
for (int i = 0; i < rows.Length; i++)
{
listView_Layr.Items.Add(new ListViewItem(new string[] { rows[i]["ViewOrder"].ToString(), rows[i]["LayerName"].ToString(), rows[i]["TableOrShapeFile"].ToString() }));
com_MainMap.Items.Add(rows[i]["TableOrShapeFile"].ToString());
CommonFun.AddLayer(rows[i]["TableOrShapeFile"].ToString(), this.mapImage, 5, -13);
}
//刷新Com_MainMap的Index
RefreshComMainMapIndex();
//清空详细显示
tex_LayerName.Text = "";
tex_MapFile.Text = "";
tex_MinLabelZoom.Text = "";
tex_MaxLabelZoom.Text = "";
tex_ShowOrder.Text = "";
tex_LabelLayerColName.Text = "";
//初始化mapImage
this.mapImage.ActiveTool = SharpMap.Forms.MapImage.Tools.Pan;
if (this.mapImage.Map.Layers.Count > 0)
{
try
{
this.mapImage.Map.ZoomToExtents();
}
catch
{ }
if (mapImage.Map.Zoom == 0.0)
{
mapImage.Map.Zoom = 1.0;
}
this.mapImage.Map.MinimumZoom = Global.MapImageMinView;
this.mapImage.Map.MaximumZoom = mapImage.Map.Zoom * 2;
this.mapImage.Refresh();
label_ZoomRuler.Text = "比例尺 1:" + Convert.ToString(Math.Round(mapImage.Map.Zoom, 0));
}
btn_MapSave.Visible = false;
btn_MapAbort.Visible = false;
}
private void bindrpt()
{
asd.dt = new DataTable();
pager_org.TableName = "(select * from OM_PXJH_SQ as a left join OM_SP as b on a.PX_SJID=b.SPFATHERID where SPZT='y' and SPLX='LSPX' union all select * from OM_PXJH_SQ as a left join OM_SP as b on a.PX_SJID1=b.SPFATHERID where SPZT='y' and SPLX='NDPXJH')t";
pager_org.PrimaryKey = "PX_ID";
pager_org.ShowFields = "* ";
pager_org.OrderField = "PX_BM,PX_FS,PX_BH";
pager_org.StrWhere = StrWhere();
pager_org.OrderType = 1;//升序排列
pager_org.PageSize = 15;
UCPaging1.PageSize = pager_org.PageSize;
pager_org.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org);
CommonFun.Paging(dt, rptPXJH, UCPaging1, palNoData);
asd.dt = dt;
double xshj = 0;
double rshj = 0;
foreach (DataRow dr in dt.Rows)
{
xshj += CommonFun.ComTryDouble(dr["PX_SJXS"].ToString());
rshj += CommonFun.ComTryDouble(dr["PX_SJRS"].ToString());
}
foreach (RepeaterItem item in rptPXJH.Controls)
{
if (item.ItemType == ListItemType.Footer)
{
((Label)item.FindControl("XSHJ")).Text = xshj.ToString();
((Label)item.FindControl("RSHJ")).Text = rshj.ToString();
break;
}
}
if (palNoData.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
protected void btn_plexport_OnClick(object sender, EventArgs e)
{
string sqltext = "";
sqltext = "select CB_YearMonth,ST_WORKNO,ST_NAME,DEP_NAME,KQ_CHUQIN,KQ_CBTS,CB_TZTS,CB_BIAOZ,(CB_BIAOZ*(isnull(KQ_CBTS,0)+CB_TZTS)) as CB_MonthCB,CB_BuShangYue,(CB_BIAOZ*(isnull(KQ_CBTS,0)+CB_TZTS)+CB_BuShangYue) as CB_HeJi,CB_BeiZhu from (select * from OM_CanBu left join OM_KQTJ on (OM_CanBu.CB_STID=OM_KQTJ.KQ_ST_ID and OM_CanBu.CB_YearMonth=OM_KQTJ.KQ_DATE) left join TBDS_STAFFINFO on OM_CanBu.CB_STID=TBDS_STAFFINFO.ST_ID left join TBDS_DEPINFO on TBDS_STAFFINFO.ST_DEPID=TBDS_DEPINFO.DEP_CODE)t where " + StrWhere() + " order by DEP_NAME";
System.Data.DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext);
string filename = "餐补统计" + DateTime.Now.ToString("yyyyMMdd") + ".xls";
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", System.Web.HttpContext.Current.Server.UrlEncode(filename)));
HttpContext.Current.Response.Clear();
//1.读取Excel到FileStream
using (FileStream fs = File.OpenRead(System.Web.HttpContext.Current.Server.MapPath("餐补统计.xls")))
{
IWorkbook wk = new HSSFWorkbook(fs); //创建workbook对象
ISheet sheet0 = wk.GetSheetAt(0); //创建第一个sheet
for (int i = 0; i < dt.Rows.Count; i++)
{
IRow row = sheet0.CreateRow(i + 1);
ICell cell0 = row.CreateCell(0);
cell0.SetCellValue(i + 1);
for (int j = 0; j < 4; j++)
{
row.CreateCell(j + 1).SetCellValue(dt.Rows[i][j].ToString().Trim());
}
for (int k = 4; k < dt.Columns.Count - 1; k++)
{
row.CreateCell(k + 1).SetCellValue(CommonFun.ComTryDouble(dt.Rows[i][k].ToString().Trim()));
}
row.CreateCell(dt.Columns.Count).SetCellValue(dt.Rows[i][dt.Columns.Count - 1].ToString().Trim());
}
for (int i = 0; i <= dt.Columns.Count; i++)
{
sheet0.AutoSizeColumn(i);
}
sheet0.ForceFormulaRecalculation = true;
MemoryStream file = new MemoryStream();
wk.Write(file);
HttpContext.Current.Response.BinaryWrite(file.GetBuffer());
HttpContext.Current.Response.End();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string wherestr = " where 1=1";
if (CBOrg.Checked)
{
string selectorgid=DropDownList1.SelectedValue;
if (selectorgid=="1")
{
wherestr += " and ChuangShuo.OrganizeID in (select OrganizeID from Organize)";
}
else
{
wherestr += " and ChuangShuo.OrganizeID in (select OrganizeID from Organize where organizeid=" + selectorgid + " or parentid=" + selectorgid + ")";
}
}
else
{
wherestr += " and ChuangShuo.OrganizeID in (select OrganizeID from Organize where organizeid=" + Session["OrganizeID"].ToString() + " or parentid=" + Session["OrganizeID"].ToString() + ")";
}
if (CBDateTime.Checked)
{
if (StartDate.Text.Length==0 || EndDate.Text.Length==0)
{
CommonFun.Show(this, "请选择起止日期!");
return;
}
else
{
wherestr += " and ChuangShuo.HoldDate between '" + StartDate.Text + "' and '" + EndDate.Text + "'";
}
}
string selectstr = @"SELECT ChuangShuo.HoldDate, ChuangShuo.HoldAddr, ChuangShuo.ComeZhzrs,
ChuangShuo.Xchmsrs, ChuangShuo.jfrs, ChuangShuo.Pxrs, ChuangShuo.shgrs, ChuangShuo.Dzkrs,
ChuangShuo.tgrs, ChuangShuo.Field1, ChuangShuo.Field2, ChuangShuo.Field3, ChuangShuo.Field4,
ChuangShuo.Field5, Organize.OrgName FROM ChuangShuo INNER JOIN Organize ON
ChuangShuo.OrganizeID = Organize.OrganizeID " + wherestr;
Session["selectstr"] = selectstr;
int recount = BindData();
LPage.Visible = true;
LPage.Text = "共" + recount.ToString() + "条记录，每页" + GridView1.PageSize.ToString() + "条记录";
}
protected void GetData()
{
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParamGroupBy(pager);
CommonFun.Paging(dt, grvRK, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
btnXTFP.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
btnXTFP.Visible = true;
}
}
private void BindDetail()
{
sqlText = "select * from CM_KAIPIAO_DETAIL where cId='" + hidTaskId.Value + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlText);
GridView1.DataSource = dt;
GridView1.DataBind();
decimal tot_money = 0;
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tot_money += CommonFun.ComTryDecimal(dt.Rows[i]["kpmoney"].ToString());
}
lb_select_money.Text = tot_money.ToString();
}
}
public ActionResult ResourceTypeModify(Reception_ResourceType model)
{
if (string.IsNullOrEmpty(model.RT_ID))
{
model.RT_ID = CommonFun.GenerGuid();
model.ImgPath = "";
model.CreateTime = DateTime.Now;
//添加资源分类
_reception_ResourceType.Insert(model);
}
else
{
//修改资源分类
_reception_ResourceType.Update(model);
}
return(RedirectToAction("ResourceType"));
}
private void bindGrid()
{
pager_org.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org);
CommonFun.Paging(dt, rptProNumCost, UCPaging1, palNoData);
if (palNoData.Visible)
{
UCPaging1.Visible = false;
btnXTFP.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
btnXTFP.Visible = true;//分页控件中要显示的控件
}
}
protected void gridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "MemDelete")
{
Cultural.Model.Member mem = new Cultural.Model.Member();
mem = bll.GetModel(int.Parse(e.CommandArgument.ToString()));
if (Session[Common.Session_MemStatus].ToString() != "5" && mem.Status == "5")
{
CommonFun.Show(this.Page, "您无权删除超级管理员！");
}
else
{
mem.Status = "7";
bll.Update(mem);
BindData();
}
}
}
