private void Update_TimeShopRemainTime()
{
if (NrTSingleton <NkCharManager> .Instance.m_kMyCharInfo == null)
{
return;
}
this.m_i64RemainTime = NrTSingleton <NkCharManager> .Instance.m_kMyCharInfo.NextRefreshTime - PublicMethod.GetCurTime();
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref this.m_strRemainTime, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("3302"),
"timestring",
NrTSingleton <NrTableTimeShopManager> .Instance.GetTimeToString(this.m_i64RemainTime)
});
this.m_lbTimeShopRemain.SetText(this.m_strRemainTime);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
switch (PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("action")))
{
case "GetUserControlClass": //得到用户表单分类
GetUserControlClass(context);
break;
case "GetMainUserControlByPage": //得到主表单分页列表
GetMainUserControlByPage(context);
break;
case "GetUserControlByPage": //得到用户表单分页列表
GetUserControlByPage(context);
break;
case "GetAllUserControl": //得到所有用户表单列表
GetAllUserControl(context);
break;
case "GetMainUserControlEntity": //得到主表单实体
GetMainUserControlEntity(context);
break;
case "GetAllChildUserControlsById": //得到指定主表单的所有子表单
GetAllChildUserControlsById(context);
break;
case "AddMainForm": //增加主表单
AddMainForm(context);
break;
case "EditMainForm": //修改主表单
EditMainForm(context);
break;
case "DelMainForm": //删除主表单
DelMainForm(context);
break;
case "AddUserControlToMain": //增加子表单到主表单中
AddUserControlToMain(context);
break;
case "RemoveUserControlFromMain": //移除子表单从主表单中
RemoveUserControlFromMain(context);
break;
case "EditMainUserControlsState": //修改主表单下指定子表单的状态
EditMainUserControlsState(context);
break;
//子表单相关操作
case "AddChildForm": //增加子表单
AddChildForm(context);
break;
case "EditChildForm": //修改子表单
EditChildForm(context);
break;
case "DelChildForm": //删除子表单
DelChildForm(context);
break;
case "GetChildUserControlEntity": //得到子表单实体
GetChildUserControlEntity(context);
break;
}
}
private void BuildTree()
{
tpZY.Root.Clear();
Coolite.Ext.Web.TreeNode root = new Coolite.Ext.Web.TreeNode();
root.Text = "-1";
root.NodeID = "辨识单元";
tpZY.Root.Add(root);
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("select * from CS_BASEINFOSET where FID={0} order by INFOID", PublicMethod.ReadXmlReturnNode("ZY", this)));
DataTable dt = OracleHelper.Query(strSql.ToString()).Tables[0];
foreach (DataRow r in dt.Rows)
{
//Coolite.Ext.Web.TreeNode asyncNode = new Coolite.Ext.Web.TreeNode();
AsyncTreeNode asyncNode = new AsyncTreeNode();
asyncNode.Text = r["INFONAME"].ToString();
asyncNode.NodeID = "z" + r["INFOID"].ToString();
//AddGZRW_Temp(asyncNode.Nodes, r["INFOID"].ToString());
//AddGZRW(asyncNode.Nodes, r["INFOID"].ToString());
root.Nodes.Add(asyncNode);
}
}
private void save_excel(int mode)
{
if (mode == 1)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Excel files (*.xls)|*.xls";
saveFileDialog.FilterIndex = 0;
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = true;
saveFileDialog.Title = "导出Excel文件到";
DateTime now = DateTime.Now;
saveFileDialog.FileName = now.Year.ToString().PadLeft(2)
+ now.Month.ToString().PadLeft(2, '0')
+ now.Day.ToString().PadLeft(2, '0') + "-"
+ now.Hour.ToString().PadLeft(2, '0')
+ now.Minute.ToString().PadLeft(2, '0')
+ now.Second.ToString().PadLeft(2, '0');
saveFileDialog.ShowDialog();
Stream myStream = saveFileDialog.OpenFile();
StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
string str = "";
try
{
//写标题
for (int i = 0; i < this.dataGridView1.ColumnCount; i++)
{
if (i > 0)
{
str += ",";
}
str += this.dataGridView1.Columns[i].HeaderText;
}
str = "\t" + str;
sw.WriteLine(str);
//写内容
for (int j = 0; j < this.dataGridView1.Rows.Count; j++)
{
string tempStr = "";
for (int k = 0; k < this.dataGridView1.Columns.Count; k++)
{
if (k > 0)
{
tempStr += ",";
}
tempStr += this.dataGridView1.Rows[j].Cells[k].Value.ToString();
}
tempStr = (j + 1).ToString() + "," + tempStr;
sw.WriteLine(tempStr);
}
sw.Close();
myStream.Close();
}
catch (Exception)
{
//MessageBox.Show(ex.ToString());
}
finally
{
sw.Close();
myStream.Close();
}
}
else if (mode == 0)
{
string[,] data = new string[this.dataGridView1.Rows.Count - 1, this.dataGridView1.Columns.Count];
for (int i = 0; i < this.dataGridView1.Rows.Count - 1; i++)
{
for (int j = 0; j < this.dataGridView1.Columns.Count; j++)
{
data[i, j] = this.dataGridView1.Rows[i].Cells[j].Value.ToString();
}
}
while (data[0, 0] != null)
{
string[,] temp_same_date = new string[data.GetLength(0), data.GetLength(1)];
string[,] temp_diff_date = new string[data.GetLength(0), data.GetLength(1)];
int g = 0;
int h = 0;
for (int k = 0; k < data.GetLength(0); k++)
{
string date_temp = data[0, 1];
if (data[k, 1] != date_temp)
{
temp_diff_date[g, 0] = data[k, 0];
temp_diff_date[g, 1] = data[k, 1];
temp_diff_date[g, 2] = data[k, 2];
g++;
}
else
{
temp_same_date[h, 0] = data[k, 0];
temp_same_date[h, 1] = data[k, 1];
temp_same_date[h, 2] = data[k, 2];
h++;
}
}
data = new string[temp_diff_date.GetLength(0), temp_diff_date.GetLength(1)];
for (int k = 0; k < temp_diff_date.GetLength(0); k++)
{
data[k, 0] = temp_diff_date[k, 0];
data[k, 1] = temp_diff_date[k, 1];
data[k, 2] = temp_diff_date[k, 2];
}
string save_file_name = this.textBox1.Text + "\\" + "report\\" + temp_same_date[0, 1] + ".xls";
string save_file_path = this.textBox1.Text + "\\" + "report\\";
Directory.CreateDirectory(save_file_path);
if (!File.Exists(save_file_name))
{
File.Create(save_file_name).Close();
}
StreamWriter sw = new StreamWriter(save_file_name, false, Encoding.UTF8);
string str = "";
//写标题
str = "," + "序列号" + "," + "日期" + "," + "时间";
sw.WriteLine(str);
//写内容
for (int j = 0; j < temp_same_date.GetLength(0); j++)
{
string tempStr = "";
for (int k = 0; k < temp_same_date.GetLength(1); k++)
{
if (k > 0)
{
tempStr += ",";
}
tempStr += temp_same_date[j, k];
}
if (tempStr != ",,")
{
tempStr = (j + 1).ToString() + "," + tempStr;
sw.WriteLine(tempStr);
}
}
sw.Flush();
sw.Close();
}
}
else if (mode == 2)
{
System.Data.DataTable dt = (System.Data.DataTable)dataGridView1.DataSource;
if (dt == null || dt.Rows.Count == 0)
{
return;
}
// 创建Excel文档，保存格式 Office2007 xlsx.
// 需要引用：Microsoft.Office.Interop.Excel.dll 12.0版本的支持Office2007.
while (dt.Rows[0][0] != "")
{
string[,] temp_same_date = new string[dt.Rows.Count, dt.Columns.Count]; //定义2维数组长度
string[,] temp_diff_date = new string[dt.Rows.Count, dt.Columns.Count]; //定义2维数组长度
int g = 0;
int h = 0;
for (int k = 0; k < dt.Rows.Count; k++)
{
string date_temp = dt.Rows[0][1].ToString();
if (date_temp == "")
{
return;
}
if (dt.Rows[k][1].ToString() != date_temp)
{
temp_diff_date[g, 0] = dt.Rows[k][0].ToString();
temp_diff_date[g, 1] = dt.Rows[k][1].ToString();
temp_diff_date[g, 2] = dt.Rows[k][2].ToString();
g++;
}
else
{
temp_same_date[h, 0] = dt.Rows[k][0].ToString();
temp_same_date[h, 1] = dt.Rows[k][1].ToString();
temp_same_date[h, 2] = dt.Rows[k][2].ToString();
h++;
}
}
//temp_same_date = temp_same_date.Where(s => !string.IsNullOrEmpty(s)).ToArray();
dt.Clear();
for (int k = 0; k < temp_diff_date.GetLength(0); k++) //将不同的数据重新写入表格中
{
DataRow dr = dt.NewRow();
for (int j = 0; j < temp_diff_date.GetLength(1); j++)
{
dr[j] = temp_diff_date[k, j];
}
dt.Rows.Add(dr);
}
/*
* for (int k = 0; k < temp_diff_date.GetLength(0); k++)
* {
* dt.Rows[k][0] = temp_diff_date[k, 0];
* dt.Rows[k][1] = temp_diff_date[k, 1];
* dt.Rows[k][2] = temp_diff_date[k, 2];
* }
*/
string save_file_name = this.textBox1.Text + "\\" + "report\\" + temp_same_date[0, 1] + ".xlsx";
string save_file_path = this.textBox1.Text + "\\" + "report\\";
Directory.CreateDirectory(save_file_path);
/*
* if (!File.Exists(save_file_name))
* File.Create(save_file_name).Close();
* else
* {
* System.IO.File.Delete(save_file_name);
* }
*/
if (File.Exists(save_file_name))
{
System.IO.File.Delete(save_file_name); //如果原始excel文件存在，删除该文件
}
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel._Workbook workBook = excel.Workbooks.Add(); //新建文件
Microsoft.Office.Interop.Excel._Worksheet workSheet = (Microsoft.Office.Interop.Excel._Worksheet)workBook.ActiveSheet; //新建sheet
object misValue = System.Reflection.Missing.Value;
//excel.DisplayAlerts = false; // 不显示告警
int rowIndex;
int colIndex;
int page;
Range range_1, range_2, range_3;
//取得标题并保存
String Current_date = DateTime.Now.ToString("yyyyMMdd");
String Number = "记录单编码: " + Current_date + "0001";
/*
* workSheet.Cells[1, 1] = "电池序列号记录单";
* Range range_1 = (Range)workSheet.get_Range("A1", "E1");
* range_1.Merge(0);
* range_1.HorizontalAlignment = XlVAlign.xlVAlignCenter;
* workSheet.Cells[1, 6] = "记录单编码: " + Current_date + "0001";
* Range range_2 = (Range)workSheet.get_Range("F1", "I1");
* range_2.Merge(0);
* range_2.HorizontalAlignment = XlVAlign.xlVAlignCenter;
*/
int same_date_length = 0;
for (h = 0; h < temp_same_date.GetLength(0); h++)
{
if (temp_same_date[h, 0] != null)
{
same_date_length++;
}
}
if (same_date_length % 100 == 0)
{
page = same_date_length / 100;
}
else
{
page = same_date_length / 100 + 1;
}
for (int k = 0; k < page; k++)
{
rowIndex = 1;
colIndex = 0;
workSheet.Cells[54 + k * 58, 7] = "签名及日期:";
///合并单元格
workSheet.Cells[1 + k * 58, 1] = "电池序列号记录单";
workSheet.Cells[1 + k * 58, 6] = Number;
range_1 = (Range)workSheet.get_Range("A" + Convert.ToString(1 + k * 58), "E" + Convert.ToString(1 + k * 58));
range_1.Merge(0);
range_1.HorizontalAlignment = XlVAlign.xlVAlignCenter;
range_2 = (Range)workSheet.get_Range("F" + Convert.ToString(1 + k * 58), "I" + Convert.ToString(1 + k * 58));
range_2.Merge(0);
range_2.HorizontalAlignment = XlVAlign.xlVAlignCenter;
for (int i = 0; i < dt.Columns.Count; i++)
{
colIndex++;
workSheet.Cells[2 + k * 58, colIndex + 1] = dt.Columns[i].ColumnName; //保存标题
workSheet.Cells[2 + k * 58, colIndex + 6] = dt.Columns[i].ColumnName; //保存标题
workSheet.Cells[2 + k * 58, 1] = "序号";
workSheet.Cells[2 + k * 58, 6] = "序号";
}
//保存数据到execl
for (int i = k * 100; i < (k + 1) * 100; i++)
{
rowIndex++;
colIndex = 0;
/*
* if (temp_same_date[i, 1] != null)
* {
* workSheet.Cells[rowIndex+1, 1] = i + 1; //保存数量编号到第一列
* }
*
*/
if (i % 100 < 50 && i < same_date_length)
{
workSheet.Cells[rowIndex + 1 + k * 58, 1] = i + 1;
}
else
if (i < same_date_length)
{
workSheet.Cells[rowIndex + 1 + k * 58 - 50, 6] = i + 1;
}
for (int j = 0; j < temp_same_date.GetLength(1); j++)
{
colIndex++;
if (i % 100 < 50)
{
workSheet.Cells[rowIndex + 1 + k * 58, colIndex + 1] = temp_same_date[i, j]; //保存具体数据到excel
}
else
{
workSheet.Cells[rowIndex + 1 + k * 58 - 50, colIndex + 6] = temp_same_date[i, j];
}
//workSheet.Cells.Borders.get_Item(XlBordersIndex.xlEdgeTop).LineStyle =Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;
}
}
//画边框，字体居中
range_3 = (Range)workSheet.get_Range("A" + Convert.ToString(1 + k * 58), "I" + Convert.ToString(52 + k * 58));
//横向居中
range_3.HorizontalAlignment = XlVAlign.xlVAlignCenter;
///字体大小
range_3.Font.Size = 10;
///字体
range_3.Font.Name = "黑体";
///行高
//range_3.RowHeight = 24;
//自动调整列宽
range_3.EntireColumn.AutoFit();
//填充颜色
//range_3.Interior.ColorIndex = 20;
//设置单元格边框的粗细
range_3.Cells.Borders.LineStyle = 1;
}
//文件保存
workSheet.SaveAs(save_file_name); //保存文件
workBook.Close(); //关闭引用
excel.Quit(); //退出excel
PublicMethod.Kill(excel); //调用kill当前excel进程
releaseObject(workSheet); //释放COM对象
releaseObject(workBook);
releaseObject(excel);
GC.Collect();
//MessageBox.Show(string.Format("{0} 文档生成成功.", filePath));
}
return;
}
}
public void InitSet(MYTH_TYPE e_MythType, int i32CharKind, long i64SolID)
{
this.m_MythType = e_MythType;
this.m_i32CharKind = i32CharKind;
this.m_i64SolID = i64SolID;
string textureFromBundle = "ui/itemshop/itemshop_elixir01";
this.m_DT_elixir.SetTextureFromBundle(textureFromBundle);
NrMyCharInfo myCharInfo = NrTSingleton <NkCharManager> .Instance.GetMyCharInfo();
if (myCharInfo != null)
{
long num = 0L;
if (this.m_MythType == MYTH_TYPE.MYTHTYPE_LEGEND)
{
num = myCharInfo.GetCharSubData(eCHAR_SUBDATA.CHAR_SUBDATA_LEGENDMAKETIME);
base.SetShowLayer(1, true);
base.SetShowLayer(2, false);
}
else if (this.m_MythType == MYTH_TYPE.MYTHTYPE_EVOLUTION)
{
num = myCharInfo.GetCharSubData(eCHAR_SUBDATA.CHAR_SUBDATA_MYTH_EVOLUTION_TIME);
base.SetShowLayer(1, false);
base.SetShowLayer(2, true);
}
long curTime = PublicMethod.GetCurTime();
if (curTime > num)
{
base.CloseNow();
return;
}
long iSec = num - curTime;
int num2 = NkUserInventory.GetInstance().Get_First_ItemCnt(50317);
long num3 = PublicMethod.GetTotalDayFromSec(iSec);
long hourFromSec = PublicMethod.GetHourFromSec(iSec);
if (this.m_MythType == MYTH_TYPE.MYTHTYPE_LEGEND)
{
base.SetShowLayer(1, true);
base.SetShowLayer(2, false);
if (hourFromSec > 0L)
{
num3 += 1L;
}
if ((long)num2 < num3)
{
this.m_MaxItemUseNum = num2;
}
else
{
this.m_MaxItemUseNum = (int)num3;
}
}
else if (this.m_MythType == MYTH_TYPE.MYTHTYPE_EVOLUTION)
{
num3 *= 2L;
base.SetShowLayer(1, false);
base.SetShowLayer(2, true);
if (hourFromSec > 0L)
{
if (hourFromSec > 12L)
{
num3 += 2L;
}
else
{
num3 += 1L;
}
}
this.m_MaxItemUseNum = (int)num3;
}
this.SetItemText();
}
}
public override void Update()
{
int noticeCount = this.GetNoticeCount();
if (0 < noticeCount)
{
if (this.count != noticeCount)
{
int num = noticeCount;
this.menuNotice.Visible = true;
this.menuNotice.Text = num.ToString();
this.count = num;
}
}
else if (this.menuNotice.Visible)
{
this.menuNotice.Visible = false;
}
List <ITEM_MALL_ITEM> group = NrTSingleton <ItemMallItemManager> .Instance.GetGroup(50);
if (group == null)
{
return;
}
bool flag = false;
for (int i = 0; i < group.Count; i++)
{
ITEM_MALL_ITEM iTEM_MALL_ITEM = group[i];
if (iTEM_MALL_ITEM != null)
{
ITEM_VOUCHER_DATA itemVoucherDataFromItemID = NrTSingleton <ItemMallItemManager> .Instance.GetItemVoucherDataFromItemID(iTEM_MALL_ITEM.m_Idx);
if (itemVoucherDataFromItemID != null)
{
eVOUCHER_TYPE ui8VoucherType = (eVOUCHER_TYPE)itemVoucherDataFromItemID.ui8VoucherType;
long voucherRemainTime = NrTSingleton <NkCharManager> .Instance.m_kMyCharInfo.GetVoucherRemainTime(ui8VoucherType, itemVoucherDataFromItemID.i64ItemMallID);
if (voucherRemainTime > 0L && NrTSingleton <NkCharManager> .Instance.m_kMyCharInfo.IsUseVoucher(ui8VoucherType, itemVoucherDataFromItemID.i64ItemMallID))
{
flag = true;
break;
}
}
}
}
if (!flag)
{
NrMyCharInfo kMyCharInfo = NrTSingleton <NkCharManager> .Instance.m_kMyCharInfo;
long charSubData = kMyCharInfo.GetCharSubData(eCHAR_SUBDATA.CHAR_SUBDATA_FREETICKET_PREMINUM_TIME);
if (PublicMethod.GetCurTime() > charSubData)
{
flag = true;
}
charSubData = kMyCharInfo.GetCharSubData(eCHAR_SUBDATA.CHAR_SUBDATA_FREETICKET_HEARTS_TIME);
if (PublicMethod.GetCurTime() > charSubData)
{
flag = true;
}
}
if (flag && this.btShopMenu.Visible)
{
this.ShopNotice.Visible = true;
}
else
{
this.ShopNotice.Visible = false;
}
}
public void ShowinfiBattleList()
{
NrPersonInfoUser charPersonInfo = NrTSingleton <NkCharManager> .Instance.GetCharPersonInfo(1);
this.m_infiLBRecordList.Clear();
foreach (INFIBATTLE_RECORDINFO current in this.infirecord_list)
{
string text = string.Empty;
string text2 = string.Empty;
NewListItem newListItem = new NewListItem(this.m_infiLBRecordList.ColumnNum, true, string.Empty);
DateTime dueDate = PublicMethod.GetDueDate(current.i64BattleTime);
text = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("293");
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text2, new object[]
{
text,
"month",
dueDate.Month,
"day",
dueDate.Day,
"hour",
dueDate.Hour,
"min",
dueDate.Minute,
"sec",
dueDate.Second
});
newListItem.SetListItemData(1, text2, null, null, null);
UIBaseInfoLoader loader;
if (current.i64AttackPersonID == charPersonInfo.GetPersonID())
{
if (current.ui8WinType == 0)
{
loader = NrTSingleton <UIImageInfoManager> .Instance.FindUIImageDictionary("Win_I_ArrowUp2");
text2 = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2313");
}
else
{
loader = NrTSingleton <UIImageInfoManager> .Instance.FindUIImageDictionary("Win_I_ArrowMaintain");
text2 = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2314");
}
}
else if (current.ui8WinType == 0)
{
loader = NrTSingleton <UIImageInfoManager> .Instance.FindUIImageDictionary("Win_I_ArrowDown2");
text2 = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2316");
}
else
{
loader = NrTSingleton <UIImageInfoManager> .Instance.FindUIImageDictionary("Win_I_ArrowMaintain");
text2 = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2315");
}
newListItem.SetListItemData(6, loader, null, null, null);
newListItem.SetListItemData(2, text2, null, null, null);
text = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("471");
if (current.i64AttackPersonID == charPersonInfo.GetPersonID())
{
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text2, new object[]
{
text,
"targetname",
TKString.NEWString(current.szDefenceCharName),
"count",
current.i16DefenceCharLevel
});
}
else
{
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text2, new object[]
{
text,
"targetname",
TKString.NEWString(current.szAttackCharName),
"count",
current.i16AttackCharLevel
});
}
newListItem.SetListItemData(3, text2, null, null, null);
newListItem.SetListItemData(4, string.Empty, current, new EZValueChangedDelegate(this.ClickShareReply), null);
newListItem.SetListItemData(5, string.Empty, current, new EZValueChangedDelegate(this.ClickReplay), null);
if (current.i64AttackPersonID == charPersonInfo.GetPersonID())
{
if (current.ui8WinType == 0)
{
if (current.i32OldRank == current.i32NewRank)
{
text2 = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2232");
}
else
{
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text2, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2230"),
"rankcount",
current.i32OldRank - current.i32NewRank
});
}
}
else
{
text2 = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2232");
}
}
else if (current.ui8WinType == 0)
{
if (current.i32OldRank == current.i32NewRank)
{
text2 = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2232");
}
else
{
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text2, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2231"),
"rankcount",
current.i32NewRank - current.i32OldRank
});
}
}
else
{
text2 = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2232");
}
newListItem.SetListItemData(7, text2, null, null, null);
newListItem.SetListItemData(12, NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("289"), null, null, null);
newListItem.SetListItemData(13, NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("496"), null, null, null);
this.m_infiLBRecordList.Add(newListItem);
}
this.m_infiLBRecordList.RepositionItems();
}
protected void Page_Load(object sender, EventArgs e)
{
if (base.Request.QueryString["Type"] == "getuser")
{
try
{
DataTable dtMbr = PublicMethod.QueryDataset("select mNum,mLevel,mName,mBalance,convert(varchar(100), mPastdate,23) as 'mPastdate',mType,mPwd,mIntegral from membersinfo where mNum='" + base.Request.QueryString["Id"] + "'").Tables[0];
if (dtMbr.Rows.Count > 0)
{
if (int.Parse(DateTime.Parse(dtMbr.Rows[0]["mPastdate"].ToString()).ToString("yyyyMMdd")) < int.Parse(DateTime.Now.ToString("yyyyMMdd")))
{
base.Response.Write("OutDate");
}
else
{
string sql = "";
DataTable dtLevel = PublicMethod.QueryDataset("select lName,lDiscount,ljifen from memberlevel where lNum='" + dtMbr.Rows[0]["mLevel"].ToString() + "'").Tables[0];
if (dtLevel.Rows.Count > 0)
{
sql = dtMbr.Rows[0]["mNum"].ToString() + "@" + dtLevel.Rows[0]["lName"].ToString() + "@" + dtMbr.Rows[0]["mName"].ToString() + "@" + dtMbr.Rows[0]["mBalance"].ToString() + "@" + dtMbr.Rows[0]["mPastdate"].ToString() + "@" + dtLevel.Rows[0]["lDiscount"].ToString() + "@" + dtLevel.Rows[0]["ljifen"].ToString();
}
base.Response.Write(sql);
}
}
else
{
base.Response.Write("false");
}
}
catch
{
base.Response.Write("false");
}
}
else if (base.Request.QueryString["Type"] == "postdate")
{
try
{
DataTable dtPwd = PublicMethod.QueryDataset("select mNum from membersinfo where mNum='" + base.Request.QueryString["Id"] + "' and mPwd='" + DESEncrypt.Encrypt(base.Request.QueryString["pwd"]) + "'").Tables[0];
if (dtPwd.Rows.Count > 0)
{
string C_Id = base.Request.QueryString["XFId"];
string str = "insert into Consumption_Back (C_Id,Card_Id,Type,Addtime,Users,Remark,Shop,ShopId,Money,PayType,Consum_Type,ClientName) values (";
object name9 = str;
name9 = string.Concat(new object[] { name9, "'", C_Id, "','", base.Request.QueryString["Id"], "','终端消费','", DateTime.Now.ToString(), "','", HttpContext.Current.Session["Webnames"], "','终端支付'" });
name9 = string.Concat(new object[] { name9, ",'", HttpContext.Current.Session["Webshopname"], "','", HttpContext.Current.Session["Webshopnum"], "','", base.Request.QueryString["money"], "','余额支付','','", base.Request.QueryString["txtname"], "')" }) + "insert into Consumption_Back_select (C_Id,Card_Id,Type,Addtime,Users,Remark,Shop,ShopId,Money,PayType,Consum_Type,ClientName) values (";
name9 = string.Concat(new object[] { name9, "'", C_Id, "','", base.Request.QueryString["Id"], "','终端消费','", DateTime.Now.ToString(), "','", HttpContext.Current.Session["Webnames"], "','终端支付'" });
string name5 = string.Concat(new object[] { name9, ",'", HttpContext.Current.Session["Webshopname"], "','", HttpContext.Current.Session["Webshopnum"], "','", base.Request.QueryString["money"], "','余额支付','','", base.Request.QueryString["txtname"], "')" });
PublicMethod.Execute(name5 + " update membersinfo set mBalance=mBalance-" + base.Request.QueryString["money"] + ",mIntegral=mIntegral+" + base.Request.QueryString["AllJifen"] + " where mNum='" + base.Request.QueryString["Id"] + "'");
base.Response.Write("true");
}
else
{
base.Response.Write("pwd");
}
}
catch
{
base.Response.Write("false");
}
}
else if (base.Request.QueryString["Type"] == "getId")
{
base.Response.Write("XF" + base.Request.QueryString["Id"] + DateTime.Now.ToString("yyyyMMddHHmmssffff"));
}
else if (base.Request.QueryString["Type"] == "checkId")
{
DataTable dt = PublicMethod.QueryDataset("select Id from Consumption_Back where C_Id ='" + base.Request.QueryString["Id"] + "'").Tables[0];
if (dt.Rows.Count > 0)
{
base.Response.Write("true");
}
else
{
base.Response.Write("false");
}
}
}
private static void AddTypeMethod(IHTMLDiv parent, CompilationMethod type, Action <string> UpdateLocation)
{
if (type == null)
{
return;
}
var div = new IHTMLDiv().AttachTo(parent);
div.style.marginTop = "0.1em";
div.style.fontFamily = ScriptCoreLib.JavaScript.DOM.IStyle.FontFamilyEnum.Verdana;
div.style.whiteSpace = ScriptCoreLib.JavaScript.DOM.IStyle.WhiteSpaceEnum.nowrap;
var i = new PublicMethod().AttachTo(div);
i.style.verticalAlign = "middle";
i.style.marginRight = "0.5em";
var w = new StringBuilder();
w.Append(type.Name);
w.Append("(");
type.GetParameters().ForEach(
(p, pi) =>
{
if (pi > 0)
{
w.Append(", ");
}
w.Append(p.Name);
}
);
w.Append(")");
var s = new IHTMLAnchor {
innerText = w.ToString()
}.AttachTo(div);
s.href = "#";
s.style.textDecoration = "none";
s.style.color = JSColor.System.WindowText;
Action onclick = delegate
{
};
s.onclick +=
e =>
{
e.PreventDefault();
s.focus();
UpdateLocation(type.Name);
onclick();
};
s.onfocus +=
delegate
{
s.style.backgroundColor = JSColor.System.Highlight;
s.style.color = JSColor.System.HighlightText;
};
s.onblur +=
delegate
{
s.style.backgroundColor = JSColor.None;
s.style.color = JSColor.System.WindowText;
};
onclick =
delegate
{
//var children = new IHTMLDiv().AttachTo(div);
//children.style.paddingLeft = "2em";
//a.GetTypes().ForEach(
// (Current, Next) =>
// {
// AddType(GetNamespaceContainer(children, Current), Current, UpdateLocation);
// ScriptCoreLib.Shared.Avalon.Extensions.AvalonSharedExtensions.AtDelay(
// 50,
// Next
// );
// }
//);
var NextClickHide = default(Action);
var NextClickShow = default(Action);
NextClickHide =
delegate
{
//children.Hide();
onclick = NextClickShow;
};
NextClickShow =
delegate
{
//children.Show();
onclick = NextClickHide;
};
onclick = NextClickHide;
};
}
public void ShowPlunderList()
{
NrPersonInfoUser charPersonInfo = NrTSingleton <NkCharManager> .Instance.GetCharPersonInfo(1);
this.m_LBRecordList.Clear();
foreach (PLUNDER_RECORDINFO current in this.record_list)
{
string text = string.Empty;
string text2 = string.Empty;
NewListItem newListItem = new NewListItem(this.m_LBRecordList.ColumnNum, true, string.Empty);
DateTime dueDate = PublicMethod.GetDueDate(current.i64BattleTime);
text = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("293");
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text2, new object[]
{
text,
"month",
dueDate.Month,
"day",
dueDate.Day,
"hour",
dueDate.Hour,
"min",
dueDate.Minute,
"sec",
dueDate.Second
});
newListItem.SetListItemData(2, text2, null, null, null);
if (current.i64AttackPersonID == charPersonInfo.GetPersonID())
{
newListItem.SetListItemData(0, false);
if (current.byWinType == 0)
{
text2 = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("139");
}
else
{
text2 = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("140");
}
}
else
{
newListItem.SetListItemData(0, true);
if (current.byWinType == 0)
{
text2 = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("142");
}
else
{
text2 = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("141");
}
}
newListItem.SetListItemData(3, text2, null, null, null);
text = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("471");
if (current.i64AttackPersonID == charPersonInfo.GetPersonID())
{
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text2, new object[]
{
text,
"targetname",
TKString.NEWString(current.szDefenceCharName),
"count",
current.i16DefenceCharLevel
});
}
else
{
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text2, new object[]
{
text,
"targetname",
TKString.NEWString(current.szAttackCharName),
"count",
current.i16AttackCharLevel
});
}
newListItem.SetListItemData(4, text2, null, null, null);
newListItem.SetListItemData(5, current.i64PlunderMoney.ToString(), null, null, null);
newListItem.SetListItemData(6, NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("496"), current, new EZValueChangedDelegate(this.ClickShareReply), null);
newListItem.SetListItemData(7, NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("289"), current, new EZValueChangedDelegate(this.ClickReplay), null);
newListItem.SetListItemData(7, true);
this.m_LBRecordList.Add(newListItem);
}
this.m_LBRecordList.RepositionItems();
}
private void AutoDoSth()//自动处理流程-干部走动
{
PublicMethod.AutoSetMovePlanStatus();
}
public void SetInfo(GS_GUILDWAR_INFO_ACK ACK)
{
string text = string.Empty;
if (NrTSingleton <GuildWarManager> .Instance.CanGetGuildWarReward())
{
this.m_boxNotice.Hide(false);
}
else
{
this.m_boxNotice.Hide(true);
}
if (ACK.i64GuildID[1] > 0L)
{
base.SetShowLayer(1, true);
base.SetShowLayer(2, true);
this.m_lbApplyNoti.Hide(true);
if (ACK.bGuildWarTimeState == 2)
{
this.m_lbGuildWarTimeState.SetText(NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2979"));
}
else if (ACK.bGuildWarTimeState == 3)
{
int num;
if (ACK.i32WarMatchPoint[0] > ACK.i32WarMatchPoint[1])
{
num = 0;
}
else if (ACK.i32WarMatchPoint[0] < ACK.i32WarMatchPoint[1])
{
num = 1;
}
else
{
num = ((ACK.i32Rank[0] >= ACK.i32Rank[1]) ? 0 : 1);
}
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2980"),
"targetname",
TKString.NEWString(ACK.strGuildName[num])
});
this.m_lbGuildWarTimeState.SetText(text);
NrTSingleton <FormsManager> .Instance.AttachEffectKey("FX_GUILDWAR_VICTORYMARK", this.m_dtVictoryEffect[num], this.m_dtVictoryEffect[num].GetSize());
if (num == 0)
{
TsAudioManager.Instance.AudioContainer.RequestAudioClip("UI_SFX", "ETC", "GUILD_WIN", new PostProcPerItem(NrAudioClipDownloaded.OnEventAudioClipDownloadedImmedatePlay));
}
else
{
TsAudioManager.Instance.AudioContainer.RequestAudioClip("UI_SFX", "ETC", "GUILD_LOSE", new PostProcPerItem(NrAudioClipDownloaded.OnEventAudioClipDownloadedImmedatePlay));
}
}
else
{
base.SetShowLayer(2, false);
}
}
else
{
base.SetShowLayer(1, false);
base.SetShowLayer(2, false);
this.m_lbApplyNoti.Hide(false);
}
NrTSingleton <GuildWarManager> .Instance.bIsGuildWar = ACK.bIsGuildWar;
NrTSingleton <GuildWarManager> .Instance.bIsGuildWarCancelReservation = ACK.bIsCancelReservation;
this.SetApplyButton();
for (int i = 0; i < 2; i++)
{
if (ACK.i64GuildID[i] > 0L)
{
this.m_btGuild[i].Data = ACK.i64GuildID[i];
string guildPortraitURL = NrTSingleton <NkCharManager> .Instance.GetGuildPortraitURL(ACK.i64GuildID[i]);
WebFileCache.RequestImageWebFile(guildPortraitURL, new WebFileCache.ReqTextureCallback(this.ReqWebImageCallback), this.m_dtGMark[i]);
text = TKString.NEWString(ACK.strGuildName[i]);
if (NrTSingleton <GuildWarManager> .Instance.bIsGuildWar && i == 0)
{
text = string.Format("{0}{1}", NrTSingleton <CTextParser> .Instance.GetTextColor("1401"), TKString.NEWString(ACK.strGuildName[i]));
}
this.m_lbGuildName[i].SetText(text);
this.m_lbMatchPoint[i].SetText(ACK.i32WarMatchPoint[i].ToString());
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("1685"),
"count",
ACK.i32Rank[i]
});
this.m_lbGuildWarRank[i].SetText(text);
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("1786"),
"count",
ACK.i16Level[i]
});
this.m_lbGuildLevel[i].SetText(text);
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("1303"),
"count1",
ACK.i16CurMemberNum[i],
"count2",
ACK.i16MaxMemberNum[i]
});
this.m_lbMemberCount[i].SetText(text);
long num2 = 0L;
long num3 = 1L;
GUILD_EXP guildLevelUpInfo = NrTSingleton <NkGuildExpManager> .Instance.GetGuildLevelUpInfo(ACK.i16Level[i]);
if (guildLevelUpInfo != null)
{
num2 = ACK.i64Exp[i] - guildLevelUpInfo.m_nExp;
}
GUILD_EXP guildLevelUpInfo2 = NrTSingleton <NkGuildExpManager> .Instance.GetGuildLevelUpInfo(ACK.i16Level[i] + 1);
if (guildLevelUpInfo2 != null && guildLevelUpInfo != null)
{
num3 = guildLevelUpInfo2.m_nExp - guildLevelUpInfo.m_nExp;
if (0L > num3)
{
num3 = 0L;
}
}
float num4 = (float)num2 / (float)num3;
if (1f < num4)
{
num4 = 1f;
}
this.m_dtExpBar[i].SetSize(this.m_fExpWidth[i] * num4, this.m_dtExpBar[i].GetSize().y);
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("603"),
"count1",
num2,
"count2",
num3
});
this.m_lbExpBarText[i].SetText(text);
if (ACK.i64BirthDate[i] > 0L)
{
DateTime dueDate = PublicMethod.GetDueDate(ACK.i64BirthDate[i]);
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("602"),
"year",
dueDate.Year,
"month",
dueDate.Month,
"day",
dueDate.Day
});
this.m_lbGuildBirth[i].SetText(text);
}
else
{
this.m_lbGuildBirth[i].SetText(string.Empty);
}
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref text, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("1041"),
"count",
ACK.i32WarPoint[i]
});
this.m_lbAccrueHonor[i].SetText(text);
}
}
}
private string exportDataTableToExcel(System.Data.DataTable dataTable, string fileName, string filePath)
{
Microsoft.Office.Interop.Excel.Application excel;
Microsoft.Office.Interop.Excel._Workbook workBook;
Microsoft.Office.Interop.Excel._Worksheet workSheet;
object misValue = System.Reflection.Missing.Value;
excel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Range excelRange;
workBook = excel.Workbooks.Add(misValue);
workSheet = (Microsoft.Office.Interop.Excel._Worksheet)workBook.ActiveSheet;
int rowIndex = 3;
int colIndex = 1;
((Microsoft.Office.Interop.Excel.Range)workSheet.Rows["1:2", System.Type.Missing]).RowHeight = 40;
excel.ActiveSheet.Rows[1].Font.Size = 16;
excel.ActiveSheet.Rows[1].Font.Bold = true;
excelRange = (Range)workSheet.get_Range("A1", "G1");
excelRange.Merge(0);
excel.Cells[1, 1] = "遵义长征村镇银行制卡明细统计表";
excel.ActiveSheet.Rows[1].HorizontalAlignment = XlHAlign.xlHAlignCenter;
excel.ActiveSheet.Rows[2].Font.Size = 12;
excel.ActiveSheet.Rows[2].Font.Bold = true;
excelRange = (Range)workSheet.get_Range("A2", "G2");
excelRange.Merge(0);
excel.Cells[2, 1] = "统计开始时间：" + fileName.Split('-')[0] + " 统计结束时间：" + fileName.Split('-')[1];
excel.ActiveSheet.Rows[2].HorizontalAlignment = XlHAlign.xlHAlignLeft;
excelRange = (Range)workSheet.get_Range("A1", "G1");
excelRange.ColumnWidth = 15;
excel.Cells[3, 1] = "序号";
//取得标题
foreach (DataColumn col in dataTable.Columns)
{
colIndex++;
excel.Cells[3, colIndex] = col.ColumnName;
}
//取得表格中的数据
foreach (DataRow row in dataTable.Rows)
{
rowIndex++;
colIndex = 1;
foreach (DataColumn col in dataTable.Columns)
{
colIndex++;
if (colIndex == 3)
{
excel.Cells[rowIndex, colIndex].NumberFormatLocal = "@";
}
excel.Cells[rowIndex, 1] = rowIndex - 3;
excel.Cells[rowIndex, colIndex] =
row[col.ColumnName].ToString().Trim();
//设置表格内容居中对齐
//workSheet.get_Range(excel.Cells[rowIndex, colIndex],
// excel.Cells[rowIndex, colIndex]).HorizontalAlignment =
// Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
}
}
excelRange = (Range)workSheet.get_Range(string.Format("A{0}", rowIndex + 1), string.Format("F{0}", rowIndex + 1));
excelRange.Merge(0);
excelRange.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
excel.Cells[rowIndex + 1, 1] = "制卡张数:";
excel.Cells[rowIndex + 1, 7] = rowIndex - 3 + "张";
excel.Cells[rowIndex + 1, 7].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
excelRange.Merge(0);
((Range)workSheet.Rows[string.Format("{0}:{0}", rowIndex + 1), System.Type.Missing]).RowHeight = 40;
excel.Visible = true;
string saveFile = filePath + "\\" + fileName + ".xls";
if (File.Exists(saveFile))
{
File.Delete(saveFile);
}
workBook.SaveAs(saveFile, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue,
misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive,
misValue, misValue, misValue, misValue, misValue);
dataTable = null;
workBook.Close(true, misValue, misValue);
excel.Quit();
PublicMethod.Kill(excel);//调用kill当前excel进程
releaseObject(workSheet);
releaseObject(workBook);
releaseObject(excel);
if (!File.Exists(saveFile))
{
return(null);
}
return(saveFile);
}
public IActionResult Schedule()
{
ViewBag.Schedule = PublicMethod.JsonSerialize <List <ScheduleViewModel> >(_service.GetSchedule(_customerTimezone));
return(View());
}
private void btnOK_Click(object sender, EventArgs e)
{
if (comboBox1.Text == "当天数据")
{
//sql语句中存入你需要的导出数据的语句
string sql = "select MACID , MACKEY, MCUID , QECODE, BATCHNO, CONVERT(varchar(100), CREATEDON, 120) 'CREATEDON', CONVERT(varchar(100), EndDate, 120)'EndDate' from dbo.YiBao where DATEDIFF(D, CREATEDON,GETDATE())=0";
DataTable dt = DBHelper.GetDataTable(sql);
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Excel(*.xls)|*.xls";
sfd.FileName = DateTime.Now.ToString("yyyyMMddhhmmss");
if (sfd.ShowDialog() == DialogResult.OK)
{
string fileName = sfd.FileName;
PublicMethod.OutToExcelFromDataTable(fileName, dt, true);
}
}
else if (comboBox1.Text == "前一天的数据")
{
//sql语句中存入你需要的导出数据的语句
string sql = "select MACID , MACKEY, MCUID , QECODE, BATCHNO, CONVERT(varchar(100), CREATEDON, 120) 'CREATEDON', CONVERT(varchar(100), EndDate, 120)'EndDate' from dbo.YiBao where DATEDIFF(D, CREATEDON,GETDATE())=1";
DataTable dt = DBHelper.GetDataTable(sql);
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Excel(*.xls)|*.xls";
sfd.FileName = DateTime.Now.ToString("yyyyMMddhhmmss");
if (sfd.ShowDialog() == DialogResult.OK)
{
string fileName = sfd.FileName;
PublicMethod.OutToExcelFromDataTable(fileName, dt, true);
}
}
else if (comboBox1.Text == "本周数据")
{
//sql语句中存入你需要的导出数据的语句
string sql = @"select MACID , MACKEY, MCUID , QECODE, BATCHNO, CONVERT(varchar(100), CREATEDON, 120) 'CREATEDON', CONVERT(varchar(100), EndDate, 120)'EndDate' from dbo.YiBao where DATEDIFF(week, CREATEDON,GETDATE())=0; ";
DataTable dt = DBHelper.GetDataTable(sql);
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Excel(*.xls)|*.xls";
sfd.FileName = DateTime.Now.ToString("yyyyMMddhhmmss");
if (sfd.ShowDialog() == DialogResult.OK)
{
string fileName = sfd.FileName;
PublicMethod.OutToExcelFromDataTable(fileName, dt, true);
DialogResult = System.Windows.Forms.DialogResult.OK;
}
}
else
if (comboBox1.Text == "当月数据")
{
//sql语句中存入你需要的导出数据的语句
string sql = @"select MACID , MACKEY, MCUID , QECODE, BATCHNO, CONVERT(varchar(100), CREATEDON, 120) 'CREATEDON', CONVERT(varchar(100), EndDate, 120)'EndDate' from dbo.YiBao where DATEDIFF(M, CREATEDON,GETDATE())=0; ";
DataTable dt = DBHelper.GetDataTable(sql);
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Excel(*.xls)|*.xls";
sfd.FileName = DateTime.Now.ToString("yyyyMMddhhmmss");
if (sfd.ShowDialog() == DialogResult.OK)
{
string fileName = sfd.FileName;
PublicMethod.OutToExcelFromDataTable(fileName, dt, true);
DialogResult = System.Windows.Forms.DialogResult.OK;
}
}
else if (comboBox1.Text == "上月数据")
{
//sql语句中存入你需要的导出数据的语句
string sql =
@"select MACID , MACKEY, MCUID , QECODE, BATCHNO, CONVERT(varchar(100), CREATEDON, 120) 'CREATEDON', CONVERT(varchar(100), EndDate, 120)'EndDate' from dbo.YiBao where DATEDIFF(M, CREATEDON,GETDATE())=1 ";
DataTable dt = DBHelper.GetDataTable(sql);
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Excel(*.xls)|*.xls";
sfd.FileName = DateTime.Now.ToString("yyyyMMddhhmmss");
if (sfd.ShowDialog() == DialogResult.OK)
{
string fileName = sfd.FileName;
PublicMethod.OutToExcelFromDataTable(fileName, dt, true);
DialogResult = System.Windows.Forms.DialogResult.OK;
}
}
}
public void SetList(GS_MINE_BATTLE_RESULT_LIST_ACK _ACK, NkDeserializePacket kDeserializePacket)
{
if (_ACK.i16Page != 1 && _ACK.ui8Count == 0)
{
return;
}
if (_ACK.i16Page == 1 && _ACK.ui8Count == 0)
{
NoticeIconDlg.SetIcon(ICON_TYPE.MINE_RECORED, false);
}
string empty = string.Empty;
this.m_Box_Page.Text = _ACK.i16Page.ToString();
this.m_nlbRecordList.Clear();
this.m_page = _ACK.i16Page;
for (int i = 0; i < (int)_ACK.ui8Count; i++)
{
NewListItem newListItem = new NewListItem(this.m_nlbRecordList.ColumnNum, true, string.Empty);
MINE_BATTLE_RESULT_INFO packet = kDeserializePacket.GetPacket <MINE_BATTLE_RESULT_INFO>();
if (i == 0)
{
NrTSingleton <MineManager> .Instance.m_i64FirstLegionActionID_By_List = packet.i64LegionActionID;
}
NrTSingleton <MineManager> .Instance.m_i64LastLegionActionID_By_List = packet.i64LegionActionID;
newListItem.Data = packet;
if (packet.i64BattleTime >= 0L)
{
DateTime dueDate = PublicMethod.GetDueDate(packet.i64BattleTime);
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref empty, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("602"),
"year",
dueDate.Year,
"month",
dueDate.Month,
"day",
dueDate.Day
});
newListItem.SetListItemData(1, empty, null, null, null);
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref empty, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("1527"),
"hour",
string.Format("{0:00}", dueDate.Hour),
"min",
string.Format("{0:00}", dueDate.Minute),
"sec",
string.Format("{0:00}", dueDate.Second)
});
newListItem.SetListItemData(2, empty, null, null, null);
}
newListItem.SetListItemData(3, this.GetListText(packet), null, null, null);
newListItem.SetListItemData(4, NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("1088"), packet, new EZValueChangedDelegate(this.OnClickBattleResult), null);
if (packet.i32ItemUnique > 0 && packet.i32ItemNum != 0)
{
newListItem.SetListItemData(6, new ITEM
{
m_nItemUnique = packet.i32ItemUnique,
m_nItemNum = packet.i32ItemNum
}, null, null, null);
}
else
{
UIBaseInfoLoader loader = NrTSingleton <UIImageInfoManager> .Instance.FindUIImageDictionary("Win_I_Attack");
newListItem.SetListItemData(6, loader, null, null, null);
}
this.m_nlbRecordList.Add(newListItem);
}
this.m_nlbRecordList.RepositionItems();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
if (SysVisitor.Instance.IsGuest)
{
context.Response.Write(
new JsonMessage {
Success = false, Data = "-99", Message = "登录已过期，请重新登录"
}.ToString()
);
context.Response.End();
}
int k;
var json = HttpContext.Current.Request["json"];
var rpm = new RequestParamModel <Dic>(context)
{
CurrentContext = context, Action = context.Request["action"]
};
if (!string.IsNullOrEmpty(json))
{
rpm = JSONhelper.ConvertToObject <RequestParamModel <Dic> >(json);
rpm.CurrentContext = context;
}
switch (rpm.Action)
{
case "category": //读取字典类别
context.Response.Write(DicBll.Instance.DicCategoryJson());
break;
case "add_cate": //添加字典类别
var dc = new DicCategory {
Code = rpm.Request("code"),
Title = rpm.Request("title"),
Sortnum = PublicMethod.GetInt(rpm.Request("sortnum")),
Remark = rpm.Request("remark")
};
AddCategory(dc, context);
break;
case "edit_cate":
dc = new DicCategory {
KeyId = PublicMethod.GetInt(rpm.Request("keyid")),
Code = rpm.Request("code"),
Title = rpm.Request("title"),
Sortnum = PublicMethod.GetInt(rpm.Request("sortnum")),
Remark = rpm.Request("remark")
};
EditCategory(dc, context);
break;
case "del_cate":
var cateId = PublicMethod.GetInt(rpm.Request("cateId"));
DelCategory(cateId, context);
break;
case "add":
k = DicBll.Instance.Add(rpm.Entity);
context.Response.Write(new JsonMessage {
Success = k > 0, Data = k.ToString(), Message = (k > 0 ? "添加成功！" : "字典编码已存在,请更改编码。")
}.ToString());
break;
case "edit":
if (rpm.KeyId == rpm.Entity.ParentId)
{
context.Response.Write(new JsonMessage {
Success = false, Data = "0", Message = "上级字典不能与当前字典相同！"
}.ToString());
context.Response.End();
}
Dic d = new Dic();
d.InjectFrom(rpm.Entity);
d.KeyId = rpm.KeyId;
k = DicBll.Instance.Edit(d);
context.Response.Write(new JsonMessage {
Success = k > 0, Data = k.ToString(), Message = (k > 0 ? "编辑成功！" : "字典编码已存在,请更改编码。")
}.ToString());
break;
case "del":
k = DicBll.Instance.Delete(rpm.KeyId);
var msg = "删除成功。";
switch (k)
{
case 0:
msg = "参数错误！";
break;
case 2:
msg = "请先删除子字典数据。";
break;
}
context.Response.Write(new JsonMessage {
Success = k == 1, Data = k.ToString(), Message = msg
}.ToString());
break;
case "code":
var category = DicCategoryDal.Instance.GetWhere(new { Code = rpm.Request("code") }).FirstOrDefault();
context.Response.Write(DicBll.Instance.GetDicListBy(category == null ? 0 : category.KeyId));
break;
default: //字典列表
var categoryId = PublicMethod.GetInt(rpm.Request("categoryId"));
string dicJson = DicBll.Instance.GetDicListBy(categoryId);
context.Response.Write(dicJson);
break;
}
}
private void SetItemText()
{
NrMyCharInfo myCharInfo = NrTSingleton <NkCharManager> .Instance.GetMyCharInfo();
if (myCharInfo != null)
{
long num = 0L;
if (this.m_MythType == MYTH_TYPE.MYTHTYPE_LEGEND)
{
num = myCharInfo.GetCharSubData(eCHAR_SUBDATA.CHAR_SUBDATA_LEGENDMAKETIME);
}
else if (this.m_MythType == MYTH_TYPE.MYTHTYPE_EVOLUTION)
{
num = myCharInfo.GetCharSubData(eCHAR_SUBDATA.CHAR_SUBDATA_MYTH_EVOLUTION_TIME);
}
long num2 = num - PublicMethod.GetCurTime();
if (num2 <= 0L)
{
base.CloseNow();
return;
}
long totalDayFromSec = PublicMethod.GetTotalDayFromSec(num2);
long hourFromSec = PublicMethod.GetHourFromSec(num2);
long minuteFromSec = PublicMethod.GetMinuteFromSec(num2);
string empty = string.Empty;
if (this.m_MythType == MYTH_TYPE.MYTHTYPE_LEGEND)
{
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref empty, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("3449"),
"day",
totalDayFromSec,
"hour",
hourFromSec,
"min",
minuteFromSec,
"count",
this.m_CurItemUseNum,
"minusday",
this.m_CurItemUseNum
});
this.m_LB_LegendEvolutionTime.SetText(empty);
}
else if (this.m_MythType == MYTH_TYPE.MYTHTYPE_EVOLUTION)
{
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref empty, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("3450"),
"day",
totalDayFromSec,
"hour",
hourFromSec,
"min",
minuteFromSec,
"count",
this.m_CurItemUseNum,
"minusday",
(float)this.m_CurItemUseNum * 0.5f
});
this.m_LB_MythEvolutionTime.SetText(empty);
}
this.m_Label_Count.SetText(this.m_CurItemUseNum.ToString());
}
}
protected void Button2_Click(object sender, EventArgs e)
{
string sqladd = "insert into consumes(cNum,cName,cPrice,cTnum,cIfbargain,cBargain,cJifen,cDiscount,cIfshow,cRemark,csNum,cInprice,cCount) values";
string name1 = sqladd;
sqladd = name1 + "('" + this.txtnum.Value + "','" + this.txtname.Value + "','" + this.txtprice.Value + "','" + this.ddltype.SelectedValue + "','" + this.ddlcIfbargain.SelectedValue + "','" + this.txtBargain.Value + "','" + this.ddljifen.SelectedValue + "','" + this.ddlcDiscount.SelectedValue + "','" + this.ddlIfshow.SelectedValue + "','" + this.txtremark.Text + "','" + PublicMethod.GetSessionValue("shopnum") + "','" + this.txtinprice.Value + "','" + this.txtcount.Value + "')";
this.bc.execsql(sqladd);
base.ClientScript.RegisterStartupScript(base.ClientScript.GetType(), "myscript", "<script> $.ligerDialog.success('添加成功！');</script>");
}
public static bool CurrentLocationName(NewGuildMember GuildMember, ref string strName, ref string ColorNum)
{
bool result = false;
short num = GuildMember.GetChannelID();
int mapUnique = GuildMember.GetMapUnique();
string mapNameFromUnique = NrTSingleton <MapManager> .Instance.GetMapNameFromUnique(mapUnique);
if (0 >= num || 0 >= mapUnique || mapNameFromUnique == string.Empty)
{
string text = string.Empty;
if (0L < GuildMember.GetLogOffTime())
{
long iSec = PublicMethod.GetCurTime() - GuildMember.GetLogOffTime();
long totalDayFromSec = PublicMethod.GetTotalDayFromSec(iSec);
long hourFromSec = PublicMethod.GetHourFromSec(iSec);
long minuteFromSec = PublicMethod.GetMinuteFromSec(iSec);
if (totalDayFromSec > 0L)
{
text = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2173");
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref strName, new object[]
{
text,
"count",
totalDayFromSec
});
}
else if (hourFromSec > 0L)
{
text = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2172");
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref strName, new object[]
{
text,
"count",
hourFromSec
});
}
else
{
text = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2171");
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref strName, new object[]
{
text,
"count",
minuteFromSec
});
}
}
else
{
strName = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2421");
}
if (GuildMember.GetConnected())
{
GS_NEWGUILD_MEMBER_LOG_REQ gS_NEWGUILD_MEMBER_LOG_REQ = new GS_NEWGUILD_MEMBER_LOG_REQ();
gS_NEWGUILD_MEMBER_LOG_REQ.i16ChannelID = num;
gS_NEWGUILD_MEMBER_LOG_REQ.i32MapUnique = mapUnique;
TKString.StringChar(mapNameFromUnique, ref gS_NEWGUILD_MEMBER_LOG_REQ.strMapName);
SendPacket.GetInstance().SendObject(eGAME_PACKET_ID.GS_NEWGUILD_MEMBER_LOG_REQ, gS_NEWGUILD_MEMBER_LOG_REQ);
}
}
else
{
string textFromInterface = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("1777");
byte b = 200;
num = (short)((byte)(num - (short)b));
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref textFromInterface, new object[]
{
textFromInterface,
"count",
num
});
strName = string.Format("{0}({1})", mapNameFromUnique, textFromInterface);
ColorNum = "1104";
result = true;
}
return(result);
}
//初始化出口监管仓货物入仓清单
public Report_ExSup(Customs.Entity.Store_in_headInfo CurInHead, List <Customs.Entity.Store_in_listInfo> list)
{
//先初始化界面
InitializeComponent();
//初始化报表
try
{
//初始化表头部分
//仓库编号
labWareNO.Text = CurInHead.Cust_bill_id;
labCustomCode.Text = CurInHead.Bill_id;
lbCnsNo.Text = CurInHead.Cns_no;
tbWareName.Text = "深国际华南物流监管仓";
tbreferdoc.Text = CurInHead.Refer_doc;
//发货单位
tbdeliverUnit.Text = CommonReport.GetCompanyName(CurInHead.Rs_code);
tbSumWeight.Text = "毛重:" + CurInHead.Gross_wt.ToString() + "\n" + "净重:" + CurInHead.Net_wt.ToString();//CurInHead.Gross_wt.ToString();
lbPkgs.Text = "共 " + CurInHead.Pkgs_num + " 件";
tbtotalValue.Text = CurInHead.All_value.ToString();
tbPlace.Text = CurInHead.Place;
//国别
tbOutCountry.Text = list != null?CommonReport.GetCode("102", list[0].Orign_coun, false) : ""; //WareCommon.GetCode("102", CurInHead.Trade_coun, false);
tbtaxRebate.Text = CurInHead.Tax_flag.Trim() == "1" ? "是" : "否";
tbTradetype.Text = httrade_way.Contains(CurInHead.Trade_mode) ? httrade_way[CurInHead.Trade_mode].ToString() : "";
tbInWaretype.Text = htIn_type.Contains(CurInHead.In_type) ? htIn_type[CurInHead.In_type].ToString() : "";
//目的海关
labCustom.Text = CurInHead.Ie_portName;
//报关员
//labName.Text = "报关员";
//货主
//lab.Text = "龙卓公司";
//仓库员
//labAdmin.Text = "胡藩";
BarCode.Text = CurInHead.Bill_id;
tbremark.Text = CurInHead.Remark;
labDate.Text = CurInHead.Ie_date.ToString("yyyy-MM-dd") != "1900-01-01" ? CurInHead.Ie_date.ToString("yyyy-MM-dd") : "";
//txtPkgs.Text = "200件";
if (list.Count <= 5)
{
for (int i = 1; i <= list.Count; i++)
{
#region 给table赋值
DevExpress.XtraReports.UI.XRTableCell seq = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cseq" + i, false);
seq.Text = list[i - 1].G_no.ToString();
DevExpress.XtraReports.UI.XRTableCell cCode = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cCode" + i, false);
cCode.Text = list[i - 1].Code_t;
//货物名称和规格
DevExpress.XtraReports.UI.XRTableCell cName = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cName" + i, false);
cName.Text = list[i - 1].Mg_name + "\r\n" + list[i - 1].Mg_spec + "\n" + list[i - 1].Pkgs.ToString() + "件";
//数量
string temp = PublicMethod.RemoveZero(list[i - 1].Qty_2.ToString()) == "0" ? "" : PublicMethod.RemoveZero(list[i - 1].Qty_2.ToString());
DevExpress.XtraReports.UI.XRTableCell cNum = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cNum" + i, false);
//cNum.Text = PublicMethod.RemoveZero(list[i - 1].G_qty.ToString()) + "\n" + PublicMethod.RemoveZero(list[i - 1].Qty_1.ToString()) + "\n" + temp;
cNum.Text = PublicMethod.RemoveZero(list[i - 1].Qty_1.ToString()) + "\n" + temp + "\n" + PublicMethod.RemoveZero(list[i - 1].G_qty.ToString()); //list[i - 1].G_qty.ToString();
//单位
DevExpress.XtraReports.UI.XRTableCell cUnit = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cUnit" + i, false);
//cUnit.Text = PublicMethod.GetHashValue(ht,list[i - 1].G_unit).ToString() + "\n" + PublicMethod.GetHashValue(ht,list[i - 1].Unit_code1).ToString() + "\n" + PublicMethod.GetHashValue(ht,list[i - 1].Unit_code2).ToString();
cUnit.Text = CommonReport.GetHashValue(ht, list[i - 1].Unit_code1).ToString() + "\n" + CommonReport.GetHashValue(ht, list[i - 1].Unit_code2).ToString() + "\n" + CommonReport.GetHashValue(ht, list[i - 1].G_unit).ToString(); //ht.Contains(list[i - 1].G_unit) ? ht[list[i - 1].G_unit].ToString() : "";//list[i - 1].G_unit;
DevExpress.XtraReports.UI.XRTableCell cWeight = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cWeight" + i, false);
cWeight.Text = list[i - 1].Gross + "\r\n" + list[i - 1].Net;
//币值
DevExpress.XtraReports.UI.XRTableCell cCoin = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cCoin" + i, false);
cCoin.Text = CommonReport.GetCode("118", list[i - 1].Curr_code.ToString(), true);
DevExpress.XtraReports.UI.XRTableCell cPrice = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cPrice" + i, false);
cPrice.Text = list[i - 1].Unit_price.ToString();
DevExpress.XtraReports.UI.XRTableCell cTotal = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cTotal" + i, false);
cTotal.Text = list[i - 1].Trade_ttl.ToString();
#endregion
}
}
if (list.Count > 5)
{
for (int i = 1; i <= 5; i++)
{
#region 给table赋值
DevExpress.XtraReports.UI.XRTableCell seq = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cseq" + i, false);
seq.Text = list[i - 1].G_no.ToString();
DevExpress.XtraReports.UI.XRTableCell cCode = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cCode" + i, false);
cCode.Text = list[i - 1].Code_t;
//货物名称和规格
DevExpress.XtraReports.UI.XRTableCell cName = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cName" + i, false);
cName.Text = list[i - 1].Mg_name + "\r\n" + list[i - 1].Mg_spec + "\r\n" + list[i - 1].Pkgs.ToString() + "件";
//数量
string temp = PublicMethod.RemoveZero(list[i - 1].Qty_2.ToString()) == "0"?"":PublicMethod.RemoveZero(list[i - 1].Qty_2.ToString());
DevExpress.XtraReports.UI.XRTableCell cNum = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cNum" + i, false);
//cNum.Text = PublicMethod.RemoveZero(list[i - 1].G_qty.ToString()) + "\n" + PublicMethod.RemoveZero(list[i - 1].Qty_1.ToString()) + "\n" + temp; //list[i - 1].G_qty.ToString();
cNum.Text = PublicMethod.RemoveZero(list[i - 1].Qty_1.ToString()) + "\n" + temp + "\n" + PublicMethod.RemoveZero(list[i - 1].G_qty.ToString()); //list[i - 1].G_qty.ToString();
//单位
DevExpress.XtraReports.UI.XRTableCell cUnit = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cUnit" + i, false);
//cUnit.Text = PublicMethod.GetHashValue(ht,list[i - 1].G_unit).ToString() + "\n" + PublicMethod.GetHashValue(ht,list[i - 1].Unit_code1).ToString() + "\n" + PublicMethod.GetHashValue(ht,list[i - 1].Unit_code2).ToString(); //ht.Contains(list[i - 1].G_unit) ? ht[list[i - 1].G_unit].ToString() : "";//list[i - 1].G_unit;
cUnit.Text = CommonReport.GetHashValue(ht, list[i - 1].Unit_code1).ToString() + "\n" + CommonReport.GetHashValue(ht, list[i - 1].Unit_code2).ToString() + "\n" + CommonReport.GetHashValue(ht, list[i - 1].G_unit).ToString(); //ht.Contains(list[i - 1].G_unit) ? ht[list[i - 1].G_unit].ToString() : "";//list[i - 1].G_unit;
DevExpress.XtraReports.UI.XRTableCell cWeight = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cWeight" + i, false);
cWeight.Text = list[i - 1].Gross + "\r\n" + list[i - 1].Net;
//币值
DevExpress.XtraReports.UI.XRTableCell cCoin = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cCoin" + i, false);
cCoin.Text = CommonReport.GetCode("118", list[i - 1].Curr_code.ToString(), true);
DevExpress.XtraReports.UI.XRTableCell cPrice = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cPrice" + i, false);
cPrice.Text = list[i - 1].Unit_price.ToString();
DevExpress.XtraReports.UI.XRTableCell cTotal = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cTotal" + i, false);
cTotal.Text = list[i - 1].Trade_ttl.ToString();
#endregion
}
}
}
catch (Exception ex)
{
LogManager.WriteErrorLog(ex.Message.ToString());
}
}
public SupportSolutionOptionModel()
{
Id = PublicMethod.GetToken();
selected = false;
}
/// <summary>
/// 创建页面工具栏
/// </summary>
/// <returns></returns>
public string BuildToolbar()
{
return(UserBll.Instance.PageButtons(SysVisitor.Instance.UserId, PublicMethod.GetString(Request["navid"])));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Ext.IsAjaxRequest)
{
if (!SessionBox.CheckUserSession())
{
Response.Redirect("~/Login.aspx");
}
else
{
UserHandle.InitModule(this.PageTag); //初始化此模块的权限。
if (UserHandle.ValidationHandle(PermissionTag.Browse)) //是否有浏览权限
{
if (!UserHandle.ValidationHandle(PermissionTag.Add)) //引用
{
btn_yy.Visible = false; //引用
btn_Sure.Visible = false; //全部引用
btn_C.Visible = false; //全部取消
btn_cancel.Visible = false; //取消
}
if (!UserHandle.ValidationHandle(PermissionTag.Edit)) //保存
{
btn_Save.Visible = false;
}
BuildTree();
Bindcombox(int.Parse(PublicMethod.ReadXmlReturnNode("SGLX", this)), bmStore1);
Bindcombox(int.Parse(PublicMethod.ReadXmlReturnNode("FXDJ", this)), bmStore2);
Bindcombox(int.Parse(PublicMethod.ReadXmlReturnNode("FXLX", this)), bmStore3);
string ren = PublicMethod.ReadXmlReturnNode("REN", this) + "," + PublicMethod.ReadXmlReturnNode("GUAN", this);
//bindGLDX(ren, Store1);
bindGLDX(ren, Store2);
bindGLDX(ren, Store3);
bindGLDX(ren, Store4);
Bindcombox(int.Parse(PublicMethod.ReadXmlReturnNode("SWJB", this)), bmStore5);
Bindcombox(int.Parse(PublicMethod.ReadXmlReturnNode("YHJB", this)), bmStore4);
GridPanel1.Hide();
Panel1.Hide();
//首页待办连接处理-周义生
if (Request.QueryString["H_YY"] != null)
{
tpZY.Hide();
bindH_YY();
GridPanel1.Show();
btn_Sure.Hide();
btn_C.Hide();
}
}
else
{
Session["ErrorNum"] = "0";
Response.Redirect("~/Error.aspx");
}
btn_Save.Disabled = true;
btn_yy.Disabled = true;
btn_cancel.Disabled = true;
}
}
}
public string Import(FormCollection context)
{
var filename = Request["file"];
var importCore = new ExcelImportCore();
importCore.LoadFile(Server.MapPath(filename));
var ds = importCore.GetAllTables(true);
string message = "";
List <object> list = new List <object>();
foreach (DataRow row in ds.Tables[0].Rows)
{
string srcname = PublicMethod.GetString(row["厂家名称型号"]).Trim();
if (!string.IsNullOrEmpty(srcname))
{
var srcModels = SRCDal.Instance.GetWhere(new { FSRCNAME = srcname }).ToList();
if (srcModels.Count > 0)
{
ProductViewModel model = ProductViewDal.Instance.Get(srcModels[0].FPRODUCTID);
if (model != null)
{
list.Add(new
{
FID = model.FID,
FMODEL = model.FMODEL,
FITEMID = model.FID,
FPRODUCTNAME = model.FPRODUCTNAME,
FPRODUCTTYPE = model.FPRODUCTTYPE,
FPRODUCTCODE = model.FPRODUCTCODE,
FASKQTY = row["主单位数量"].ToDecimal(),
FUNITNAME = row["主计量单位"].ToStr(),
FUNITID = model.FUNITID,
FORDERUNIT = row["采购单位"].ToStr(),
FORDERUNITQTY = row["采购单位数量"].ToDecimal(),
FBRANDID = model.FBRANDID,
FBRANDNAME = model.FBRANDNAME,
FPKGFORMAT = model.FPKGFORMAT,
FCATEGORYID = model.FTYPEID,
FWEIGHT = model.FWEIGHT,
FVOLUME = model.FVOLUME,
FSTATUS = model.FSTATUS,
FNEEDDATE = row["要求发货时间"].ToStr(),
FUPDATETIME = model.FUPDATETIME,
FSTATUSNAME = "草稿",
FWEIGHTUNIT = "KG",
FRATE = model.FRATE,
FCOLORNO = row["色号"].ToStr(),
FREMARK = row["销区备注"].ToStr(),
FWHOLESALEPRICE = model.FPRIORITYP_L_RICE,
FBATCHNO = model.FBATCHNO,
FADVQTY = 0
});
}
else
{
message += string.Format("商品编码：{0}不存在;", srcModels[0].FPRODUCTID);
}
}
else
{
message += string.Format("厂家代码：{0}不存在;", srcname);
}
}
}
return(JSONhelper.ToJson(new { list = list, message = message }));
}
private void Update_RemainTime()
{
if (NrTSingleton <NkCharManager> .Instance.m_kMyCharInfo == null)
{
return;
}
this.m_i64RemainTime = NrTSingleton <NkCharManager> .Instance.m_kMyCharInfo.NextRefreshTime - PublicMethod.GetCurTime();
this.m_lbRemainTime.SetText(NrTSingleton <NrTableTimeShopManager> .Instance.GetTimeToString(this.m_i64RemainTime));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
switch (PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("action")))
{
case "edit":
EditUser(context);
break;
case "delete":
DeleteUser(context);
break;
case "add":
AddUser(context);
break;
case "setpassword":
SetUserPassword(context);
break;
case "SetUserEnabled":
SetUserEnabled(context);
break;
case "GetEntity":
context.Response.Write(JSONhelper.ToJson(RDIFrameworkService.Instance.UserService.GetEntity(Utils.UserInfo, PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("KeyId")))));
break;
case "GetCurrentUserEntity":
context.Response.Write(JSONhelper.ToJson(RDIFrameworkService.Instance.UserService.GetEntity(Utils.UserInfo, Utils.UserInfo.Id)));
break;
case "GetCurrentUserLogOnEntity":
context.Response.Write(JSONhelper.ToJson(RDIFrameworkService.Instance.LogOnService.GetEntity(Utils.UserInfo, Utils.UserInfo.Id)));
break;
case "GetUserListByPage":
GetUserListByPage(context);
break;
case "GetDTByRole": //按角色获取用户列表
GetDTByRole(context);
break;
case "AddUserToRole":
AddUserToRole(context); //为指定用户批量添加角色
break;
case "RemoveRoleByUserId": //批量移除角色
RemoveRoleByUserId(context);
break;
case "GetUserPageDTByDepartmentId": //以组织机构主键得到用户分页数据
this.GetUserPageDTByDepartmentId(context);
break;
case "SetUserDimission": //用户离职
this.SetUserDimission(context);
break;
default:
var jsonStr = JSONhelper.ToJson(GetUserScopeList(PermissionItemScopeCode));
context.Response.Write(jsonStr);
break;
}
}
public void CheckLimitTime()
{
NrMyCharInfo myCharInfo = NrTSingleton <NkCharManager> .Instance.GetMyCharInfo();
string empty = string.Empty;
int num = 0;
long num2 = 0L;
long num3 = 0L;
COMMON_CONSTANT_Manager instance = COMMON_CONSTANT_Manager.GetInstance();
if (instance != null)
{
num = instance.GetValue(eCOMMON_CONSTANT.eCOMMON_CONSTANT_INFIBATTLE_CHARGEMAX);
num2 = myCharInfo.GetCharSubData(eCHAR_SUBDATA.CHAR_SUBDATA_INFIBATTLECOUNT);
num3 = (long)instance.GetValue(eCOMMON_CONSTANT.eCOMMON_CONSTANT_INFIBATTLE_CHARGETIME);
if (num2 < 0L)
{
num2 = 0L;
}
if (num3 < 0L)
{
num3 = 0L;
}
}
else
{
Main_UI_SystemMessage.ADDMessage(NrTSingleton <NrTextMgr> .Instance.GetTextFromNotify("684"), SYSTEM_MESSAGE_TYPE.NAGATIVE_MESSAGE);
}
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref empty, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2235"),
"count1",
num2,
"count2",
num
});
this.m_Label_LimitCount.SetText(empty);
long curTime = PublicMethod.GetCurTime();
string text = string.Empty;
if ((long)num == num2)
{
this.m_Label_chargetime.Visible = false;
this.m_ProgressBar.Value = 0f;
return;
}
long charSubData = myCharInfo.GetCharSubData(eCHAR_SUBDATA.CHAR_SUBDATA_INFIBATTLEADDCOUNT_TIME);
float value;
if (curTime <= charSubData)
{
this.m_Label_chargetime.Visible = true;
text = PublicMethod.ConvertTime(charSubData - curTime);
NrTSingleton <CTextParser> .Instance.ReplaceParam(ref empty, new object[]
{
NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2933"),
"timestring",
text
});
this.m_Label_chargetime.SetText(empty);
value = 1f - (float)(charSubData - curTime) / ((float)num3 * 60f);
}
else
{
this.m_Label_chargetime.Visible = false;
value = 1f;
}
this.m_ProgressBar.Value = value;
}
/// <summary>
/// 修改用户
/// </summary>
/// <param name="ctx">HTTP请求</param>
private void EditUser(HttpContext ctx)
{
var vUser = Utils.UserInfo;
var vId = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("id"));
var entity = RDIFrameworkService.Instance.UserService.GetEntity(vUser, vId);
if (entity == null)
{
ctx.Response.Write(new JsonMessage {
Success = false, Data = "-1", Message = "更新失败，无更新的数据！"
}.ToString());
return;
}
entity.UserName = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("UserName"));
entity.RealName = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("RealName"));
entity.Code = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("Code"));
entity.Gender = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("Gender"));
entity.Mobile = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("Mobile"));
entity.Birthday = PublicMethod.GetDateTime(WebCommon.StringHelper.GetRequestObject("Birthday"));
entity.Telephone = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("Telephone"));
entity.Title = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("Title"));
entity.Duty = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("Duty"));
entity.QICQ = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("QICQ"));
entity.Email = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("Email"));
var vCompanyName = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("vCompanyName"));
var vSubCompanyName = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("vSubCompanyName"));
var vDepartmentName = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("vDepartmentName"));
var vSubDepartmentName = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("vSubDepartmentName"));
var vWorkgroupName = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("vWorkgroupName"));
entity.CompanyName = vCompanyName == "请选择" ? string.Empty : vCompanyName;
entity.SubCompanyName = vSubCompanyName == "请选择" ? string.Empty : vSubCompanyName;
entity.DepartmentName = vDepartmentName == "请选择" ? string.Empty : vDepartmentName;
entity.SubDepartmentName = vSubDepartmentName == "请选择" ? string.Empty : vSubDepartmentName;
entity.WorkgroupName = vWorkgroupName == "请选择" ? string.Empty : vWorkgroupName;
entity.HomeAddress = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("HomeAddress"));
entity.Enabled = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("Enabled")) == "on" ? 1 : 0;
entity.Description = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("Description"));
entity.RoleId = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("vRoleId"));
entity.CompanyId = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("vCompanyId"));
entity.SubCompanyId = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("vSubCompanyId"));
entity.DepartmentId = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("vDepartmentId"));
entity.SubDepartmentId = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("vSubDepartmentId"));
entity.WorkgroupId = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("vWorkgroupId"));
if (vUser != null)
{
entity.ModifiedBy = vUser.RealName;
entity.ModifiedUserId = vUser.Id;
}
try
{
string statusCode;
string statusMessage;
RDIFrameworkService.Instance.UserService.UpdateUser(vUser, entity, out statusCode, out statusMessage);
ctx.Response.Write(statusCode == StatusCode.OKUpdate.ToString()
? new JsonMessage {
Success = true, Data = "1", Message = statusMessage
}.ToString()
: new JsonMessage {
Success = false, Data = "0", Message = statusMessage
}.ToString());
}
catch (Exception ex)
{
ctx.Response.Write(new JsonMessage {
Success = false, Data = "-1", Message = "更新失败，错误信息为：" + ex.Message
}.ToString());
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
UserBll.Instance.CheckUserOnlingState();
int k;
var json = HttpContext.Current.Request["json"];
var rpm = new RequestParamModel <User>(context)
{
CurrentContext = context, Action = context.Request["action"]
};
if (!string.IsNullOrEmpty(json))
{
rpm = JSONhelper.ConvertToObject <RequestParamModel <User> >(json);
rpm.CurrentContext = context;
}
switch (rpm.Action)
{
case "deps":
context.Response.Write(UserBll.Instance.GetDepartmentTreeData());
break;
case "roles":
context.Response.Write(UserBll.Instance.GetAllRoles());
break;
case "add":
var roleIds = rpm.Request("roles");
context.Response.Write(UserBll.Instance.AddUser(rpm.Entity, roleIds));
break;
case "update":
User u = new User();
u.InjectFrom(rpm.Entity);
u.KeyId = rpm.KeyId;
context.Response.Write(UserBll.Instance.EditUser(u));
break;
case "editpass":
k = UserBll.Instance.EditPassword(rpm.KeyId, rpm.Request("password"));
context.Response.Write(k);
break;
case "editpass2":
string oldPass = context.Request["old"];
string newPass = context.Request["new"];
context.Response.Write(UserBll.Instance.EditPassowrd(SysVisitor.Instance.UserId, oldPass, newPass));
break;
case "delete": //删除用户
context.Response.Write(UserBll.Instance.DeleteUser(rpm.KeyId));
break;
case "isadmin":
u = UserBll.Instance.GetUser(rpm.KeyId);
if (u != null)
{
var isamdin = rpm.Request("val");
u.IsAdmin = isamdin != "true";
context.Response.Write(UserBll.Instance.EditUser(u));
}
else
{
context.Response.Write(0);
}
break;
case "isdisabled": //禁用 激活 帐号
u = UserBll.Instance.GetUser(rpm.KeyId);
if (u != null)
{
var isdisabled = rpm.Request("val");
u.IsDisabled = isdisabled != "true";
context.Response.Write(UserBll.Instance.EditUser(u));
}
else
{
context.Response.Write(0);
}
break;
case "setroles": //为用户分配角色
var rolse = rpm.Request("roles");
k = UserBll.Instance.AddUserToRoles(rpm.KeyId, rolse);
context.Response.Write(k);
break;
case "getroles": //获取指定用户的角色
context.Response.Write(UserBll.Instance.GetRolesBy(rpm.KeyId));
break;
case "menus": //获取导航菜单及按钮用于用户授权
context.Response.Write(UserBll.Instance.GetNavBtnsJson(rpm.KeyId));
break;
case "authorize": //为用户授权
var data = rpm.Request("data");
if (string.IsNullOrEmpty(data))
{
context.Response.Write("参数错误！");
context.Response.End();
}
k = UserBll.Instance.UserAuthorize(data);
context.Response.Write(k);
break;
case "setdep":
var roleid = PublicMethod.GetInt(context.Request["keyid"]);
var deps = context.Request["deps"];
k = UserBll.Instance.SetDepartments(roleid, deps);
context.Response.Write(k);
break;
default:
string j = UserBll.Instance.GetJsonData(rpm.Pageindex, rpm.Pagesize, rpm.Filter, rpm.Sort, rpm.Order);
context.Response.Write(j);
break;
}
}
private static void AddTypeMethod(IHTMLDiv parent, CompilationMethod type, Action<string> UpdateLocation)
{
if (type == null)
return;
var div = new IHTMLDiv().AttachTo(parent);
div.style.marginTop = "0.1em";
div.style.fontFamily = ScriptCoreLib.JavaScript.DOM.IStyle.FontFamilyEnum.Verdana;
div.style.whiteSpace = ScriptCoreLib.JavaScript.DOM.IStyle.WhiteSpaceEnum.nowrap;
var i = new PublicMethod().AttachTo(div);
i.style.verticalAlign = "middle";
i.style.marginRight = "0.5em";
var w = new StringBuilder();
w.Append(type.Name);
w.Append("(");
type.GetParameters().ForEach(
(p, pi) =>
{
if (pi > 0)
w.Append(", ");
w.Append(p.Name);
}
);
w.Append(")");
var s = new IHTMLAnchor { innerText = w.ToString() }.AttachTo(div);
s.href = "#";
s.style.textDecoration = "none";
s.style.color = JSColor.System.WindowText;
Action onclick = delegate
{
};
s.onclick +=
e =>
{
e.PreventDefault();
s.focus();
UpdateLocation(type.Name);
onclick();
};
s.onfocus +=
delegate
{
s.style.backgroundColor = JSColor.System.Highlight;
s.style.color = JSColor.System.HighlightText;
};
s.onblur +=
delegate
{
s.style.backgroundColor = JSColor.None;
s.style.color = JSColor.System.WindowText;
};
onclick =
delegate
{
//var children = new IHTMLDiv().AttachTo(div);
//children.style.paddingLeft = "2em";
//a.GetTypes().ForEach(
// (Current, Next) =>
// {
// AddType(GetNamespaceContainer(children, Current), Current, UpdateLocation);
// ScriptCoreLib.Shared.Avalon.Extensions.AvalonSharedExtensions.AtDelay(
// 50,
// Next
// );
// }
//);
var NextClickHide = default(Action);
var NextClickShow = default(Action);
NextClickHide =
delegate
{
//children.Hide();
onclick = NextClickShow;
};
NextClickShow =
delegate
{
//children.Show();
onclick = NextClickHide;
};
onclick = NextClickHide;
};
}
