void editSheetForm_SaveSheetData(object sender, EditSheetForm.SaveSheetDataEventArgs e)
{
if (e.SheetData != null && listView_CaseParameter.SelectedItems != null && listView_CaseParameter.SelectedItems.Count > 0)
{
if (listView_CaseParameter.SelectedItems[0].Tag is MyStaticDataSourceCsv)
{
MyStaticDataSourceCsv nowDataSourceCsv = (MyStaticDataSourceCsv)listView_CaseParameter.SelectedItems[0].Tag;
if (nowDataSourceCsv.SetDataSource(e.SheetData))
{
if (e.SelectCell != null)
{
nowDataSourceCsv.SetDataLocation(e.SelectCell.Value.Y, e.SelectCell.Value.X);
}
UpdatalistView_CaseParameter(false);
}
else
{
MessageBox.Show("you data is empty \nplease check it ", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
if (nowEditItem != null)
{
tb_valueAdd.Text = nowEditItem.SubItems[2].Text;
}
}
}
}
public static bool GetCsvStaticDataSource(out IRunTimeDataSource yourStaticData, out string errorMes, string yourFormatData)
{
errorMes = null;
yourStaticData = null;
string csvPath = null;
int CodePage = 65001;
Encoding csvEncoding = null;
if (yourFormatData.Contains('-'))
{
if (!yourFormatData.MySplitIntEnd('-', out csvPath, out CodePage))
{
errorMes = string.Format("[GetCsvStaticDataSource]error in [MySplitIntEnd] with :[{0}]", yourFormatData);
return(false);
}
}
else
{
csvPath = yourFormatData;
}
try
{
csvEncoding = System.Text.Encoding.GetEncoding(CodePage);
}
catch
{
errorMes = string.Format("[GetCsvStaticDataSource]error in 【CodePage】 [{0}]", yourFormatData);
return(false);
}
csvPath = csvPath.StartsWith("@") ? csvPath.Remove(0, 1) : string.Format("{0}\\casefile\\{1}", CaseTool.rootPath, csvPath);
if (!System.IO.File.Exists(csvPath))
{
errorMes = string.Format("[GetCsvStaticDataSource]error in csv path [path not exixts] [{0}]", yourFormatData);
return(false);
}
MyCommonHelper.FileHelper.CsvFileHelper myCsv = new MyCommonHelper.FileHelper.CsvFileHelper(csvPath, csvEncoding);
try
{
yourStaticData = new MyStaticDataSourceCsv(myCsv.GetListCsvData());
}
catch (Exception ex)
{
errorMes = ex.Message;
return(false);
}
finally
{
myCsv.Dispose();
}
return(true);
}
private void listView_CaseParameter_DoubleClick(object sender, EventArgs e)
{
if (listView_CaseParameter.SelectedItems != null && listView_CaseParameter.SelectedItems.Count > 0)
{
if (listView_CaseParameter.SelectedItems[0].Tag is MyStaticDataSourceCsv)
{
MyStaticDataSourceCsv nowDataSourceCsv = (MyStaticDataSourceCsv)listView_CaseParameter.SelectedItems[0].Tag;
//ShowSheetForm f = new ShowSheetForm("", nowDataSourceCsv.GetDataSource());
EditSheetForm f = new EditSheetForm(listView_CaseParameter.SelectedItems[0].SubItems[0].Text, nowDataSourceCsv.GetDataSource(), nowDataSourceCsv.GetDataLocation());
f.StartPosition = FormStartPosition.CenterScreen;
f.SaveSheetData += editSheetForm_SaveSheetData;
f.ShowDialog();
}
}
}
public static bool GetCsvStaticDataSource(out IRunTimeDataSource yourStaticData, out string errorMes, string yourFormatData)
{
errorMes = null;
yourStaticData = null;
string csvPath = null;
int CodePage = 65001;
Encoding csvEncoding = null;
#if ALLOW_CSV_EMPTY
if (yourFormatData.StartsWith("*"))
{
int[] tempConuts;
if (!yourFormatData.Remove(0, 1).MySplitToIntArray('-', out tempConuts) || tempConuts.Length != 2)
{
errorMes = string.Format("[GetCsvStaticDataSource]error in [MySplitToIntArray] with :[{0}]", yourFormatData);
return(false);
}
if (tempConuts[0] < 1 || tempConuts[1] < 1)
{
errorMes = string.Format("[GetCsvStaticDataSource]error in [MySplitToIntArray] with :[{0}] \nYour row conut and columu conut should greater than 0 ", yourFormatData);
return(false);
}
List <string> tempRow = new List <string>(tempConuts[0]);
for (int i = 0; i < tempConuts[0]; i++)
{
tempRow.Add(null);
}
List <List <string> > tempCsvDataSource = new List <List <string> >(tempConuts[1]);
for (int i = 0; i < tempConuts[1]; i++)
{
tempCsvDataSource.Add(tempRow.ToList());
}
yourStaticData = new MyStaticDataSourceCsv(tempCsvDataSource, yourFormatData);
return(true);
}
#endif
if (yourFormatData.Contains('-'))
{
if (!yourFormatData.MySplitIntEnd('-', out csvPath, out CodePage))
{
errorMes = string.Format("[GetCsvStaticDataSource]error in [MySplitIntEnd] with :[{0}]", yourFormatData);
return(false);
}
}
else
{
csvPath = yourFormatData;
}
try
{
csvEncoding = System.Text.Encoding.GetEncoding(CodePage);
}
catch
{
errorMes = string.Format("[GetCsvStaticDataSource]error in 【CodePage】 [{0}]", yourFormatData);
return(false);
}
csvPath = csvPath.StartsWith("@") ? csvPath.Remove(0, 1) : string.Format("{0}\\FreeHttp\\{1}", MyCommonTool.rootPath, csvPath);
if (!System.IO.File.Exists(csvPath))
{
errorMes = string.Format("[GetCsvStaticDataSource]error in csv path [path not exixts] [{0}]", yourFormatData);
return(false);
}
MyCommonHelper.FileHelper.CsvFileHelper myCsv = new MyCommonHelper.FileHelper.CsvFileHelper(csvPath, csvEncoding);
try
{
yourStaticData = new MyStaticDataSourceCsv(myCsv.GetListCsvData(), yourFormatData);
}
catch (Exception ex)
{
errorMes = ex.Message;
return(false);
}
finally
{
myCsv.Dispose();
}
return(true);
}
