public string ExportCSVTranscationsReport(ViewTransactionCBE transaction)
{
Int16 IsDataFound = 0;
var filename = "TransactionDetails_" + DateTime.Now.ToString(Constants.dateTimeFormat24HForFileName) + ".csv";
FileInfo file = new FileInfo(Server.MapPath("~/Attachment/ExportFiles/" + filename));
try
{
string strstarttime = Convert.ToDateTime(transaction.StartDate).ToString("dd/MM/yyyy HH:mm:ss");
string strendtime = Convert.ToDateTime(transaction.EndDate).ToString("dd/MM/yyyy HH:mm:ss");
IsDataFound = CSVUtility.CreateCsv(file.FullName, TransactionBLL.TransDeatilsReport(strstarttime, strendtime));
if (IsDataFound == 0)
{
filename = "No Data to Export.";
}
}
catch (Exception ex)
{
HelperClass.LogMessage("Failed Export Transaction Details_ CSV " + ex);
}
string Det = JsonConvert.SerializeObject(filename, Formatting.Indented);
return(Det.Replace("\r", "").Replace("\n", ""));
}
public object ConfigProcess(string[] row)
{
if (row.Length < 7)
{
return(null);
}
RowHelper rh = new RowHelper(row);
DisassemblygirlDungeonConfig rec = new DisassemblygirlDungeonConfig();
rec.id = CSVUtility.ToInt(rh.Read()); //id
rec.name = rh.Read(); //名字
rec.iconID = rh.Read(); //图标ID
rec.directorID = CSVUtility.ToInt(rh.Read()); //脚本ID
rec.resourceID = rh.Read(); //资源ID
rec.audioID = rh.Read(); //音乐资源ID
rec.monsterGroups = rh.Read(); //怪物组
return(rec);
}
/// <summary>
/// 将csv文件导入数据库(不推荐使用)
/// </summary>
/// <param name="code">证券代码</param>
/// <param name="name">证券名称</param>
/// <param name="csvPath">csv文件路径</param>
/// <returns>受影响行数</returns>
public int ImportFromCSVAsDB(string code, string name, string csvPath)
{
DataTable dt = CSVUtility.ReadCSVAsDB(csvPath);
if (dt == null)
{
return(0);
}
else
{
int insertedLinesCount = 0;
foreach (DataRow row in dt.Rows)
{
StockDayPrice stock1 = new StockDayPrice();
stock1.Code = code;
stock1.Name = name;
stock1.Date = (DateTime)row["Date"];
stock1.Open = (double)row["Open"];
stock1.High = (double)row["High"];
stock1.Low = (double)row["Low"];
stock1.Close = (double)row["Close"];
stock1.Volume = Convert.ToDouble(row["Volume"]);//(double)会报错Specified cast is not valid.奇怪！！！超过int范围时row["Volume"]为DBNull
stock1.AdjClose = (double)row["Adj Close"];
int j = this.AddNew(stock1);
insertedLinesCount += j;
}
return(insertedLinesCount);
}
}
public object ConfigProcess(string[] row)
{
if (row.Length < 6)
{
return(null);
}
RowHelper rh = new RowHelper(row);
DisassemblygirlTrophyConfig rec = new DisassemblygirlTrophyConfig();
rec.id = CSVUtility.ToInt(rh.Read()); //id
rec.name = rh.Read(); //名字
rec.type = rh.Read(); //类型
rec.conditionType = rh.Read(); //判断类型
rec.threshold = CSVUtility.ToInt(rh.Read()); //数值
rec.iconID = rh.Read(); //图标ID
return(rec);
}
public void ParseCSV(string[] itemDatas)
{
CSVUtility uti = new CSVUtility(itemDatas);
Question = uti.GetString;
for (int i = 0; i < 5; i++)
{
if (Options == null)
{
Options = new List <string>();
}
Options.Add(uti.GetString);
}
for (int i = 0; i < 5; i++)
{
if (Answers == null)
{
Answers = new List <string>();
}
Answers.Add(uti.GetString);
}
for (int i = 0; i < 2; i++)
{
if (Notes == null)
{
Notes = new List <string>();
}
Notes.Add(uti.GetString);
}
}
public object ConfigProcess(string[] row)
{
if (row.Length < 3)
{
return(null);
}
RowHelper rh = new RowHelper(row);
MsgErrcodeConfig rec = new MsgErrcodeConfig();
rec.errcode = CSVUtility.ToInt(rh.Read()); //错误码
rec.en = rh.Read(); //英文名称
rec.ch = rh.Read(); //中文说明
return(rec);
}
public object ConfigProcess(string[] row)
{
if (row.Length < 19)
{
return(null);
}
RowHelper rh = new RowHelper(row);
DisassemblygirlWeaponConfig rec = new DisassemblygirlWeaponConfig();
rec.id = CSVUtility.ToInt(rh.Read()); //id
rec.level = CSVUtility.ToInt(rh.Read()); //级别
rec.name = rh.Read(); //名字
rec.iconID = rh.Read(); //武器图标
rec.ATK = CSVUtility.ToFloat(rh.Read()); //拆解力
rec.CRT = CSVUtility.ToFloat(rh.Read()); //爆破力
rec.SPD = CSVUtility.ToFloat(rh.Read()); //速度
rec.WOE = CSVUtility.ToFloat(rh.Read()); //半径
rec.CD = CSVUtility.ToFloat(rh.Read()); //间隔
rec.RP = CSVUtility.ToInt(rh.Read()); //价格
rec.GP = CSVUtility.ToInt(rh.Read()); //金钱
rec.resourceID = rh.Read(); //资源ID
rec.hitEffectID = rh.Read(); //击中效果资源ID
rec.audioID = rh.Read(); //音效资源ID
rec.offsetX = CSVUtility.ToFloat(rh.Read()); //武器偏移X
rec.offsetY = CSVUtility.ToFloat(rh.Read()); //武器偏移Y
rec.skillID = CSVUtility.ToInt(rh.Read()); //技能ID
rec.physicsType = CSVUtility.ToInt(rh.Read()); //物理类型0:无 | 1:穿透 | 2: 单次弹射|3: 多重弹射
rec.effectors = rh.Read(); //效果器
return(rec);
}
public object ConfigProcess(string[] row)
{
if (row.Length < 14)
{
return(null);
}
RowHelper rh = new RowHelper(row);
MsgMsgConfig rec = new MsgMsgConfig();
rec.id = CSVUtility.ToInt(rh.Read()); //id
rec.title = rh.Read(); //标题
rec.content = rh.Read(); //内容
rec.sell = new MsgMsgSellConfig[3];
for (int i = 0; i < 3; i++)
{
rec.sell[i] = new MsgMsgSellConfig();
}
rec.sell[0].id = CSVUtility.ToInt(rh.Read()); //出售获得物品1
rec.sell[0].num = CSVUtility.ToInt(rh.Read()); //出售获得物品数量1
rec.sell[1].id = CSVUtility.ToInt(rh.Read()); //出售获得物品2
rec.sell[1].num = CSVUtility.ToInt(rh.Read()); //出售获得物品数量2
rec.sell[2].id = CSVUtility.ToInt(rh.Read()); //出售获得物品3
rec.sell[2].num = CSVUtility.ToInt(rh.Read()); //出售获得物品数量3
rec.instance = new int[4];
rec.instance[0] = CSVUtility.ToInt(rh.Read()); //副本1
rec.instance[1] = CSVUtility.ToInt(rh.Read()); //副本1
rec.instance[2] = CSVUtility.ToInt(rh.Read()); //副本1
rec.instance[3] = CSVUtility.ToInt(rh.Read()); //副本1
rec.remark = rh.Read(); //备注
return(rec);
}
public string ExportCustomerAccountFilter(CustomerVehicleModel objCustomerVehicleModel)
{
var filename = "Customer_" + DateTime.Now.ToString(Constants.dateTimeFormat24HForFileName) + ".csv";
FileInfo file = new FileInfo(Server.MapPath("~/Attachment/ExportFiles/" + filename));
Int16 IsDataFound = 0;
try
{
string strQuery = " WHERE 1=1";
if (objCustomerVehicleModel.SearchEnable)
{
#region Filter Query
if (objCustomerVehicleModel.AccountId > 0)
{
strQuery += " AND CA.ACCOUNT_ID LIKE '%" + objCustomerVehicleModel.AccountId + "%'";
}
if (!string.IsNullOrEmpty(objCustomerVehicleModel.ResidentId))
{
strQuery += " AND CA.RESIDENT_ID LIKE '%" + objCustomerVehicleModel.ResidentId + "%'";
}
if (!string.IsNullOrEmpty(objCustomerVehicleModel.MobileNo))
{
strQuery += " AND CA.MOB_NUMBER LIKE '%" + objCustomerVehicleModel.MobileNo + "%' ";
}
if (!string.IsNullOrEmpty(objCustomerVehicleModel.EmailId))
{
strQuery += " AND LOWER(CA.EMAIL_ID) LIKE '%" + objCustomerVehicleModel.EmailId.ToLower() + "%' ";
}
if (!string.IsNullOrEmpty(objCustomerVehicleModel.FirstName))
{
strQuery += " AND LOWER(CA.FIRST_NAME) LIKE '%" + objCustomerVehicleModel.FirstName.ToLower() + "%' ";
}
if (!string.IsNullOrEmpty(objCustomerVehicleModel.VehRegNo))
{
strQuery += " AND LOWER(CV.VEH_REG_NO) LIKE '%" + objCustomerVehicleModel.VehRegNo.ToLower() + "%'";
}
IsDataFound = CSVUtility.CreateCsvWithTitleFilter(file.FullName, CustomerAccountBLL.GetFilterCSV(strQuery), "Customer", objCustomerVehicleModel);
#endregion
}
else
{
IsDataFound = CSVUtility.CreateCsvWithTitle(file.FullName, CustomerAccountBLL.GetFilterCSV(strQuery), "Customer");
}
if (IsDataFound == 0)
{
filename = "No Data to Export.";
}
}
catch (Exception ex)
{
HelperClass.LogMessage("Failed Export Customer CSV " + ex);
}
string Det = JsonConvert.SerializeObject(filename, Formatting.Indented);
return(Det.Replace("\r", "").Replace("\n", ""));
}
public object ConfigProcess(string[] row)
{
if (row.Length < 17)
{
return(null);
}
RowHelper rh = new RowHelper(row);
DisassemblygirlMonsterConfig rec = new DisassemblygirlMonsterConfig();
rec.id = CSVUtility.ToInt(rh.Read()); //id
rec.level = CSVUtility.ToInt(rh.Read()); //级别
rec.name = rh.Read(); //名字
rec.resourceID = rh.Read(); //资源ID
rec.explosionID = rh.Read(); //爆炸资源ID
rec.missileResourceID = rh.Read(); //投射物资源ID
rec.type = CSVUtility.ToInt(rh.Read()); //类型
rec.DEF = CSVUtility.ToFloat(rh.Read()); //防御力
rec.ANTI = CSVUtility.ToFloat(rh.Read()); //抵抗力
rec.SPD = CSVUtility.ToFloat(rh.Read()); //速度
rec.HP = CSVUtility.ToInt(rh.Read()); //生命值
rec.components = rh.Read(); //部件吊掉落配置
rec.groundDamping = CSVUtility.ToFloat(rh.Read()); //地面阻力
rec.airDamping = CSVUtility.ToFloat(rh.Read()); //空中阻力
rec.immunityEffectors = rh.Read(); //效果器免疫
rec.RP = CSVUtility.ToInt(rh.Read()); //RP
rec.GP = CSVUtility.ToInt(rh.Read()); //GP
return(rec);
}
public object ConfigProcess(string[] row)
{
if (row.Length < 16)
{
return(null);
}
RowHelper rh = new RowHelper(row);
DisassemblygirlPetConfig rec = new DisassemblygirlPetConfig();
rec.id = CSVUtility.ToInt(rh.Read()); //id
rec.level = CSVUtility.ToInt(rh.Read()); //级别
rec.name = rh.Read(); //名字
rec.iconID = rh.Read(); //图标ID
rec.resourceID = rh.Read(); //资源ID
rec.missileResourceID = rh.Read(); //投射物资源ID
rec.missileHitEffectID = rh.Read(); //投射物击中资源ID
rec.ATK = CSVUtility.ToFloat(rh.Read()); //拆解力
rec.CRT = CSVUtility.ToFloat(rh.Read()); //爆破力
rec.SPD = CSVUtility.ToFloat(rh.Read()); //速度
rec.WOE = CSVUtility.ToFloat(rh.Read()); //半径
rec.RP = CSVUtility.ToInt(rh.Read()); //价格
rec.GP = CSVUtility.ToInt(rh.Read()); //金钱
rec.missileAudioID = rh.Read(); //投射物音效资源ID
rec.physicsType = CSVUtility.ToInt(rh.Read()); //物理类型0:无 | 1:穿透 | 2: 单次弹射|3: 多重弹射
rec.effectors = rh.Read(); //效果器
return(rec);
}
private List <List <string> > ReadCSVMinusBlankLastLine(string filename)
{
if (!File.Exists(filename))
{
Debug.LogError("Love/Hate: File not found: " + filename);
return(new List <List <string> >());
}
var csv = CSVUtility.ReadCSVFile(filename, prefs.encoding);
if (string.IsNullOrEmpty(csv[csv.Count - 1][0]))
{
csv.RemoveAt(csv.Count - 1);
}
return(csv);
}
/* protected & private - Field declaration */
// ========================================================================== //
/* public - [Do~Something] Function */
public void DoInsert(string strCSV)
{
Type pType = typeof(T);
TableConfig pTableConfig = SODB_Setting.instance.GetTableConfig(pType.Name);
Dictionary <string, ColumnInfo> mapColumnInfo = Generate_ColumnInfo(pTableConfig, pType);
List <T> listInsert = CSVUtility.FromCSVText_List <T>(strCSV, Debug.LogError);
ProcessInsert(mapColumnInfo, listInsert, out bool bIsSuccess);
if (bIsSuccess)
{
OnInsert(listInsert);
rows.AddRange(listInsert);
}
Debug.Log($"ProcessInsert {strCSV}");
}
public object ConfigProcess(string[] row)
{
if (row.Length < 4)
{
return null;
}
RowHelper rh = new RowHelper(row);
DisassemblygirlGoldConfig rec = new DisassemblygirlGoldConfig();
rec.id = CSVUtility.ToInt(rh.Read()); //id
rec.name = rh.Read(); //名字
rec.iconID = rh.Read(); //图标ID
rec.value = CSVUtility.ToInt(rh.Read()); //数值
return rec;
}
public object ConfigProcess(string[] row)
{
if (row.Length < 14)
{
return(null);
}
RowHelper rh = new RowHelper(row);
DisassemblygirlGirlConfig rec = new DisassemblygirlGirlConfig();
rec.id = CSVUtility.ToInt(rh.Read()); //id
rec.level = CSVUtility.ToInt(rh.Read()); //级别
rec.name = rh.Read(); //名字
rec.resourceID = rh.Read(); //角色资源
rec.STR = CSVUtility.ToInt(rh.Read()); //力量
rec.VIT = CSVUtility.ToInt(rh.Read()); //体力
rec.DEX = CSVUtility.ToInt(rh.Read()); //灵巧
rec.SPD = CSVUtility.ToInt(rh.Read()); //速度
rec.weaponA = CSVUtility.ToInt(rh.Read()); //武器A
rec.weaponB = CSVUtility.ToInt(rh.Read()); //武器B
rec.weaponC = CSVUtility.ToInt(rh.Read()); //武器C
rec.skillA = CSVUtility.ToInt(rh.Read()); //技能A
rec.skillB = CSVUtility.ToInt(rh.Read()); //技能B
rec.skillC = CSVUtility.ToInt(rh.Read()); //技能C
return(rec);
}
public object ConfigProcess(string[] row)
{
if (row.Length < 14)
{
return(null);
}
RowHelper rh = new RowHelper(row);
DisassemblygirlSkillConfig rec = new DisassemblygirlSkillConfig();
rec.id = CSVUtility.ToInt(rh.Read()); //id
rec.name = rh.Read(); //名字
rec.iconID = rh.Read(); //技能图标
rec.ATK = CSVUtility.ToFloat(rh.Read()); //拆解力
rec.CRT = CSVUtility.ToFloat(rh.Read()); //爆破力
rec.SPD = CSVUtility.ToFloat(rh.Read()); //速度
rec.WOE = CSVUtility.ToFloat(rh.Read()); //半径
rec.CD = CSVUtility.ToFloat(rh.Read()); //冷却
rec.type = CSVUtility.ToInt(rh.Read()); //技能类型
rec.vibrateType = CSVUtility.ToInt(rh.Read()); //震动类型 0:无 | 1:命中 | 2:释放
rec.resourceID = rh.Read(); //技能动画ID
rec.hitEffectID = rh.Read(); //击中动画ID
rec.physicsType = CSVUtility.ToInt(rh.Read()); //物理类型0:无 | 1:穿透 | 2: 单次弹射 3:多重弹射
rec.effectors = rh.Read(); //效果器
return(rec);
}
public string ExportCSVCustomer()
{
var filename = "Customer_" + DateTime.Now.ToString(Constants.dateTimeFormat24HForFileName) + ".csv";
try
{
FileInfo file = new FileInfo(Server.MapPath("~/Attachment/ExportFiles/" + filename));
Int16 IsDataFound = CSVUtility.CreateCsvWithTitle(file.FullName, CustomerAccountBLL.GetAllAsCSV(), "Customer");
if (IsDataFound == 0)
{
filename = "No Data to Export.";
}
}
catch (Exception ex)
{
HelperClass.LogMessage("Failed Export Customer CSV " + ex);
}
string Det = JsonConvert.SerializeObject(filename, Formatting.Indented);
return(Det.Replace("\r", "").Replace("\n", ""));
}
public object ConfigProcess(string[] row)
{
if (row.Length < 10)
{
return(null);
}
RowHelper rh = new RowHelper(row);
DisassemblygirlMonstergroupConfig rec = new DisassemblygirlMonstergroupConfig();
rec.id = CSVUtility.ToInt(rh.Read()); //id
rec.monstersA = rh.Read(); //怪物组A
rec.monstersB = rh.Read(); //怪物组B
rec.monstersC = rh.Read(); //怪物组C
rec.monstersD = rh.Read(); //怪物组D
rec.monstersE = rh.Read(); //怪物组E
rec.boss = CSVUtility.ToInt(rh.Read()); //bossID
rec.joinCount = CSVUtility.ToInt(rh.Read()); //每次加入战场单位数量
rec.joinInterval = CSVUtility.ToFloat(rh.Read()); //加入间隔(秒)
rec.isBoss = CSVUtility.ToInt(rh.Read()); //是否是BOSS组
return(rec);
}
public object ConfigProcess(string[] row)
{
if (row.Length < 9)
{
return(null);
}
RowHelper rh = new RowHelper(row);
DisassemblygirlEffectorConfig rec = new DisassemblygirlEffectorConfig();
rec.id = CSVUtility.ToInt(rh.Read()); //id
rec.name = rh.Read(); //名字
rec.iconID = rh.Read(); //图标ID
rec.resourceID = rh.Read(); //资源ID
rec.parameter1 = CSVUtility.ToFloat(rh.Read()); //参数1
rec.parameter2 = CSVUtility.ToFloat(rh.Read()); //参数2
rec.parameter3 = CSVUtility.ToFloat(rh.Read()); //参数3
rec.parameter4 = CSVUtility.ToFloat(rh.Read()); //参数4
rec.parameter5 = CSVUtility.ToFloat(rh.Read()); //参数5
return(rec);
}
private void SearchEventH()
{
string path = @"\\192.168.145.7\nstvnoise$\FCT_NOISE\" + cmbModelH.Text + "\\";
foreach (History cell in flpnlYeildShowH.Controls.OfType <History>())
{
//cell.input = 0;
//cell.output = 0;
cell.dataH = new DataTable();
cell.dataH.Columns.Add("Date");
cell.dataH.Columns.Add("Input");
cell.dataH.Columns.Add("Output");
cell.dataH.Columns.Add("Yield");
double inputH = 0, outputH = 0;
string yieldH = string.Empty;
string nopath = path + cell.Name + "\\";
for (int i = dtpFromH.Value.Year; i <= dtpToH.Value.Year; i++)
{
string yearpath = nopath + i + "\\";
if (!Directory.Exists(yearpath))
{
return;
}
for (int j = dtpFromH.Value.Month; j <= dtpToH.Value.Month; j++)
{
string monthpath = yearpath + j.ToString("00") + "\\";
if (!Directory.Exists(monthpath))
{
return;
}
for (int k = dtpFromH.Value.Day; k <= dtpToH.Value.Day; k++)
{
string date = i + "-" + j.ToString("00") + "-" + k.ToString("00");
string[] files = Directory.GetFiles(monthpath);
foreach (string f in files)
{
if (f.Contains(date))
{
DataTable dt = new DataTable();
dt = CSVUtility.ConvertCSVtoDataTable(f);
inputH = dt.Rows.Count;
foreach (DataRow dr in dt.Rows)
{
if (dr["Judge"].ToString().Contains("OK"))
{
outputH++;
}
}
yieldH = ((outputH / inputH) * 100).ToString("00.00") + "%";
cell.dataH.Rows.Add(date, inputH, outputH, yieldH);
cell.Refresh();
dt.Clear();
inputH = 0;
outputH = 0;
}
}
}
}
}
//if (cell.input > 0 && cell.output > 0)
// cell.yeild = cell.output / cell.input;
//else
// cell.yeild = 0;
//if (cell.yeild >= 0.85)
// cell.color = Color.LimeGreen;
//else if (cell.yeild >= 0.5 && cell.yeild < 0.85)
// cell.color = Color.Yellow;
//else if (cell.yeild < 0.5 && cell.input > 0)
// cell.color = Color.Red;
//else
// cell.color = Color.Silver;
//cell.lbYeild.Text = (cell.yeild * 100).ToString("0.##") + "%";
}
}
private void SearchEvent()
{
string path = @"\\192.168.145.7\nstvnoise$\FCT_NOISE\" + cmbModel.Text + "\\";
foreach (InspectCell cell in flpnlYeildShow.Controls.OfType <InspectCell>())
{
cell.input = 0;
cell.output = 0;
string nopath = path + cell.Name + "\\";
for (int i = dtpDateFrom.Value.Year; i <= dtpDateTo.Value.Year; i++)
{
string yearpath = nopath + i + "\\";
if (!Directory.Exists(yearpath))
{
return;
}
for (int j = dtpDateFrom.Value.Month; j <= dtpDateTo.Value.Month; j++)
{
string monthpath = yearpath + j.ToString("00") + "\\";
if (!Directory.Exists(monthpath))
{
return;
}
for (int k = dtpDateFrom.Value.Day; k <= dtpDateTo.Value.Day; k++)
{
string date = i + "-" + j.ToString("00") + "-" + k.ToString("00");
string[] files = Directory.GetFiles(monthpath);
foreach (string f in files)
{
if (f.Contains(date))
{
DataTable dt = new DataTable();
dt = CSVUtility.ConvertCSVtoDataTable(f);
cell.input += dt.Rows.Count;
foreach (DataRow dr in dt.Rows)
{
if (dr["Judge"].ToString().Contains("OK"))
{
cell.output++;
}
}
dt.Clear();
}
}
}
}
}
if (cell.input > 0 && cell.output > 0)
{
cell.yeild = cell.output / cell.input;
}
else
{
cell.yeild = 0;
}
if (cell.yeild >= 0.85)
{
cell.color = Color.LimeGreen;
}
else if (cell.yeild >= 0.5 && cell.yeild < 0.85)
{
cell.color = Color.Yellow;
}
else if (cell.yeild < 0.5 && cell.input > 0)
{
cell.color = Color.Red;
}
else
{
cell.color = Color.Silver;
}
cell.lbYeild.Text = (cell.yeild * 100).ToString("0.##") + "%";
}
}
private void btnExport_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(noname))
{
MessageBox.Show("Please select the machine number!!!", "Information", MessageBoxButtons.OK);
return;
}
try
{
string path = @"\\192.168.145.7\nstvnoise$\FCT_NOISE\" + cmbModel.Text + "\\";
SaveFileDialog sf = new SaveFileDialog();
List <string[]> fr = new List <string[]>();
sf.Filter = "Excel Files (*.xlsx)|*.xlsx|All File (*.*)|*.*";
//sf.FileName = "Select Folder";
if (sf.ShowDialog() == DialogResult.OK)
{
//cell.input = 0;
//cell.output = 0;
string nopath = path + noname + "\\";
for (int i = dtpDateFrom.Value.Year; i <= dtpDateTo.Value.Year; i++)
{
string yearpath = nopath + i + "\\";
if (!Directory.Exists(yearpath))
{
return;
}
for (int j = dtpDateFrom.Value.Month; j <= dtpDateTo.Value.Month; j++)
{
string monthpath = yearpath + j.ToString("00") + "\\";
if (!Directory.Exists(monthpath))
{
return;
}
for (int k = dtpDateFrom.Value.Day; k <= dtpDateTo.Value.Day; k++)
{
string date = i + "-" + j.ToString("00") + "-" + k.ToString("00");
string[] files = Directory.GetFiles(monthpath);
foreach (string f in files)
{
if (f.Contains(date))
// File.Copy(f, Path.GetDirectoryName(sf.FileName) + "\\" + Path.GetFileName(f));
{
ExcelClass2019.OpenExcelWorkBook(@"\\192.168.145.7\nstvnoise$\Excel Form\Histogram FCT.xlsx", 2);
Cursor.Current = Cursors.WaitCursor;
CSVUtility.ConvertCSVtoDataTable(f).DatasetToExcel();
if (MessageBox.Show("Export Successfully." + Environment.NewLine + "Do you want open this?", "Notice", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
sf.FileName.SaveAndExit(true);
}
else
{
sf.FileName.SaveAndExit(false);
}
Cursor.Current = Cursors.Default;
}
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Export()
{
try
{
// PersonalityTraits.csv:
EditorUtility.DisplayProgressBar("Exporting Faction Database To CSV", "Exporting personality trait definitions...", 0);
var csv = new List <List <string> >();
csv.Add(new List <string>(new string[] { "Name", "Description" }));
for (int i = 0; i < db.personalityTraitDefinitions.Length; i++)
{
var def = db.personalityTraitDefinitions[i];
csv.Add(new List <string>(new string[] { def.name, def.description }));
}
CSVUtility.WriteCSVFile(csv, prefs.folder + "/PersonalityTraits.csv", prefs.encoding);
// RelationshipTraits.csv:
EditorUtility.DisplayProgressBar("Exporting Faction Database To CSV", "Exporting relationship trait definitions...", 40);
csv = new List <List <string> >();
csv.Add(new List <string>(new string[] { "Name", "Description" }));
for (int i = 0; i < db.relationshipTraitDefinitions.Length; i++)
{
var def = db.relationshipTraitDefinitions[i];
csv.Add(new List <string>(new string[] { def.name, def.description }));
}
CSVUtility.WriteCSVFile(csv, prefs.folder + "/RelationshipTraits.csv", prefs.encoding);
// Factions.csv:
EditorUtility.DisplayProgressBar("Exporting Faction Database To CSV", "Exporting factions...", 60);
csv = new List <List <string> >();
var row = new List <string>(new string[] { "ID", "Name", "Description", "Preset", "Color", "%Judge Parents" });
for (int i = 0; i < db.personalityTraitDefinitions.Length; i++)
{
row.Add(db.personalityTraitDefinitions[i].name);
}
row.Add("Parents");
csv.Add(row);
for (int i = 0; i < db.presets.Length; i++)
{
var preset = db.presets[i];
row = new List <string>(new string[] { "-1", preset.name, preset.description, "1", "0", "0" });
for (int j = 0; j < db.personalityTraitDefinitions.Length; j++)
{
row.Add(preset.traits[j].ToString());
}
csv.Add(row);
}
for (int i = 0; i < db.factions.Length; i++)
{
var faction = db.factions[i];
row = new List <string>(new string[] { faction.id.ToString(), faction.name, faction.description, "0", faction.color.ToString(), faction.percentJudgeParents.ToString() });
for (int j = 0; j < db.personalityTraitDefinitions.Length; j++)
{
row.Add(faction.traits[j].ToString());
}
for (int j = 0; j < faction.parents.Length; j++)
{
row.Add(db.factions[faction.parents[j]].name);
}
csv.Add(row);
}
CSVUtility.WriteCSVFile(csv, prefs.folder + "/Factions.csv", prefs.encoding);
// Relationships.csv:
EditorUtility.DisplayProgressBar("Exporting Faction Database To CSV", "Exporting relationships...", 80);
for (int i = 0; i < db.relationshipTraitDefinitions.Length; i++)
{
csv = new List <List <string> >();
row = new List <string>(new string[] { db.relationshipTraitDefinitions[i].name });
for (int j = 0; j < db.factions.Length; j++)
{
row.Add(db.factions[j].name);
}
csv.Add(row);
for (int j = 0; j < db.factions.Length; j++)
{
var judge = db.factions[j];
row = new List <string>(new string[] { judge.name });
for (int k = 0; k < db.factions.Length; k++)
{
var subject = db.factions[k];
Relationship relationship;
if (db.FindPersonalRelationship(judge.id, subject.id, out relationship))
{
row.Add(relationship.traits[i].ToString());
}
else
{
row.Add("none");
}
}
csv.Add(row);
}
CSVUtility.WriteCSVFile(csv, prefs.folder + "/Relationships_" + GetValidFilespec(db.relationshipTraitDefinitions[i].name) + ".csv", prefs.encoding);
}
}
finally
{
EditorUtility.ClearProgressBar();
}
Debug.Log("Exported " + db.name + " to CSV files in " + prefs.folder + ".", db);
}
private void btnPush_Click(object sender, EventArgs e)
{
try
{
string tempfolder = @"\\192.168.145.7\nstvnoise$\TEMP";
string errorfolder = @"\\192.168.145.7\nstvnoise$\ERROR";
List <string> errorlist = new List <string>();
site = "NSTV";
factory = "2B";
line = "L01";
process = "FCT";
multiinspect.Clear();
mutliprocess.Clear();
foreach (string item in lsbAllFileCSV.Items)
{
DataTable dt = new DataTable();
model = Path.GetFileName(item).Split('_')[1];
model = model.Replace('-', '_');
date = Path.GetFileName(item).Split('_')[2].Split('-')[0]
+ Path.GetFileName(item).Split('_')[2].Split('-')[1];
table = model + date;
gData.CreateTable(table);
gData.CreateTableData(table);
CSVUtility.ConvertCSVtoDataTable(dt, item);
foreach (DataRow dr in dt.Rows)
{
inspectdate = DateTime.Parse(dr["Date"].ToString());
serno = inspectdate.ToString("HHmmss") + dr["Number"].ToString();
lot = inspectdate.ToString("yyyyMMdd");
judge = dr["Judge"].ToString() == "OK" ? "0" : "1";
mutliprocess.Append("('").Append(serno).Append("','").Append(lot).Append("','");
mutliprocess.Append(model).Append("','").Append(site).Append("','").Append(factory).Append("','");
mutliprocess.Append(line).Append("','").Append(process).Append("','");
mutliprocess.Append(inspectdate.ToString("yyyy-MM-dd HH:mm:ss")).Append("','").Append(judge);
mutliprocess.Append("','INITAL',''), ");
//gData.InsertTable(table, serno, lot, model, site, factory, line, process, inspectdate.ToString("yyyy-MM-dd HH:mm:ss"), judge, "INITAL", "");
foreach (DataColumn dc in dt.Columns)
{
inspect = dc.ColumnName.Replace(" ", string.Empty);
if (gData.CheckInspect(inspect))
{
inspectdata = dr[dc.ColumnName].ToString();
if (inspectdata == "-" || !isDouble(inspectdata))
{
continue;
}
multiinspect.Append("('").Append(serno).Append("','").Append(lot).Append("','");
multiinspect.Append(inspectdate.ToString("yyyy-MM-dd HH:mm:ss")).Append("','");
multiinspect.Append(inspect).Append("','").Append(inspectdata).Append("','");
multiinspect.Append(judge).Append("'), ");
//gData.InsertTableData(table, serno, lot, inspectdate.ToString("yyyy-MM-dd HH:mm:ss"), inspect, inspectdata, judge);
}
}
}
multiinspect.Remove(multiinspect.Length - 2, 1);
mutliprocess.Remove(mutliprocess.Length - 2, 1);
if (!gData.InsertTableData(table, multiinspect.ToString()) && !gData.InsertTable(table, mutliprocess.ToString()))
{
if (!Directory.Exists(errorfolder))
{
Directory.CreateDirectory(errorfolder);
}
File.WriteAllLines(errorfolder + "\\" + Path.GetFileName(item), errorlist);
}
if (!Directory.Exists(tempfolder))
{
Directory.CreateDirectory(tempfolder);
}
File.Move(item, tempfolder + "\\" + Path.GetFileName(item));
}
}
catch { }
}
private void ExportDetails()
{
try
{
DataRow dr;
BuildTable();
string filePath = "";
string fromDate = dpFrom.Value.ToShortDateString();
string toDate = dpTo.Value.ToShortDateString();
dtTeam = Teams();
for (int i = 0; i <= dtTeam.Rows.Count - 1; i++)
{
dr = dtResult.NewRow();
int teamId = Convert.ToInt32(dtTeam.Rows[i]["T_ID"]);
string teamName = dtTeam.Rows[i]["T_TeamName"].ToString();
dr["TeamName"] = teamName;
dr["DateRange"] = fromDate + " - " + toDate;
int totalWorkingDays = GetNumberOfWorkingDays(dpFrom.Value, dpTo.Value);
dt = new System.Data.DataTable();
dt = GetHours(teamId, fromDate, toDate);
if (dt.Rows.Count > 0)
{
dr["BillableHours"] = dt.Rows[0]["Billable Hours"];
dr["PTOs"] = dt.Rows[0]["PTO"];
dr["EEA"] = dt.Rows[0]["EEA"];
dr["Meeting"] = dt.Rows[0]["Meeting"];
dr["Nontask"] = dt.Rows[0]["Nontask"];
dr["Others"] = dt.Rows[0]["Others"];
dr["Available Time"] = dt.Rows[0]["Available Time"];
}
dr["WorkingHours"] = totalWorkingDays * 8;
dt = new System.Data.DataTable();
dt = GetUsersCount(teamId, fromDate, toDate);
if (dt.Rows.Count > 0)
{
dr["UserCount"] = dt.Rows[0]["UsersCount"];
}
dtResult.Rows.Add(dr);
}
if (rbWithMgr.Checked)
{
filePath = "D:\\Util\\" + dpFrom.Value.ToString("MM-dd-yyyy") + "-" + dpTo.Value.ToString("MM-dd-yyyy") + ".csv";
}
else
{
filePath = "D:\\Util\\" + dpFrom.Value.ToString("MM-dd-yyyy") + "-" + dpTo.Value.ToString("MM-dd-yyyy") + "(WithoutManager).csv";
}
CSVUtility.ToCSV(dtResult, filePath);
MessageBox.Show("RU Report Generated");
}
catch (Exception ex)
{
lblStatus.Text = ex.Message;
}
}
public object ConfigProcess(string[] row)
{
if (row.Length < 19)
{
return(null);
}
RowHelper rh = new RowHelper(row);
ItemItemConfig rec = new ItemItemConfig();
rec.id = CSVUtility.ToInt(rh.Read()); //id
rec.name = rh.Read(); //名称
rec.desc = rh.Read(); //描述
rec.gain = rh.Read(); //获取途径
rec.type = CSVUtility.ToInt(rh.Read()); //类型
rec.overlap = CSVUtility.ToInt(rh.Read()); //叠加上限
rec.usetype = CSVUtility.ToInt(rh.Read()); //使用效果类型
rec.usevalue = new int[2];
rec.usevalue[0] = CSVUtility.ToInt(rh.Read()); //使用效果值1
rec.usevalue[1] = CSVUtility.ToInt(rh.Read()); //使用效果值2
rec.use_times = CSVUtility.ToInt(rh.Read()); //使用次数限制
rec.cansell = CSVUtility.ToInt(rh.Read()); //是否可出售
rec.sell = new ItemItemSellConfig[2];
for (int i = 0; i < 2; i++)
{
rec.sell[i] = new ItemItemSellConfig();
}
rec.sell[0].id = CSVUtility.ToInt(rh.Read()); //出售获得物品1
rec.sell[0].num = CSVUtility.ToInt(rh.Read()); //出售获得物品数量1
rec.sell[1].id = CSVUtility.ToInt(rh.Read()); //出售获得物品2
rec.sell[1].num = CSVUtility.ToInt(rh.Read()); //出售获得物品数量2
rec.head = rh.Read(); //小图标
rec.model = rh.Read(); //模型
rec.star = CSVUtility.ToInt(rh.Read()); //星级
rec.linkid = CSVUtility.ToInt(rh.Read()); //关联id
return(rec);
}
public string ExportCSVTranscations(ViewTransactionCBE transaction)
{
Int16 IsDataFound = 0;
var filename = "Transaction_Details_Registered_" + DateTime.Now.ToString(Constants.dateTimeFormat24HForFileName) + ".csv";
var filename1 = "Transaction_Details_UnRegistered_" + DateTime.Now.ToString(Constants.dateTimeFormat24HForFileName) + ".csv";
FileInfo file = new FileInfo(Server.MapPath("~/Attachment/ExportFiles/" + filename));
FileInfo file1 = new FileInfo(Server.MapPath("~/Attachment/ExportFiles/" + filename1));
try
{
string strstarttime = Convert.ToDateTime(transaction.StartDate).ToString("dd/MM/yyyy HH:mm:ss");
string strendtime = Convert.ToDateTime(transaction.EndDate).ToString("dd/MM/yyyy HH:mm:ss");
string strQuery = " WHERE 1=1 ";
if (strstarttime != null && strendtime != null)
{
strQuery += " AND TRANSACTION_DATETIME BETWEEN TO_DATE('" + strstarttime + "','DD/MM/YYYY HH24:MI:SS') AND TO_DATE('" + strendtime + "','DD/MM/YYYY HH24:MI:SS')";
}
else if (strstarttime != null)
{
strQuery += " AND TRANSACTION_DATETIME >= TO_DATE('" + strstarttime + "','DD/MM/YYYY HH24:MI:SS')";
}
else if (strendtime != null)
{
strQuery += " AND TRANSACTION_DATETIME <= TO_DATE('" + strendtime + "','DD/MM/YYYY HH24:MI:SS')";
}
DataTable dt = TransactionBLL.TransDeatils(strQuery);
DataView dv = new DataView(dt);
DataTable Charged = dt.AsEnumerable()
.Where(r => r.Field <decimal>("IS_REGISTERED") == 1)
.CopyToDataTable();
//DataTable Charged = (DataTable)(dv.RowFilter = "IS_BALANCE_UPDATED=1").;
if (Charged.Rows.Count > 0)
{
IsDataFound = CSVUtility.CreateCsv(file.FullName, Charged);
if (IsDataFound == 0)
{
filename = string.Empty;
}
}
DataTable UnCharged = dt.AsEnumerable()
.Where(r => r.Field <decimal>("IS_REGISTERED") != 1)
.CopyToDataTable();
if (UnCharged.Rows.Count > 0)
{
IsDataFound = CSVUtility.CreateCsv(file1.FullName, UnCharged);
if (IsDataFound == 0)
{
if (string.IsNullOrEmpty(filename))
{
filename = "No Data to Export.";
}
}
else
{
if (string.IsNullOrEmpty(filename))
{
filename = "No Data to Export.";
}
else
{
filename = filename + ";" + filename1;
}
}
}
}
catch (Exception ex)
{
filename = "No Data to Export. :" + ex.Message;
HelperClass.LogMessage("Failed Export Transaction Details_ CSV " + ex);
}
string Det = JsonConvert.SerializeObject(filename, Formatting.Indented);
return(Det.Replace("\r", "").Replace("\n", ""));
}
