public TaskData SelectTaskData(string taskCode)
{
StringUtility str = new StringUtility();
SqlHandling sh = new SqlHandling("D_Task");
DataTable dt = sh.SelectAllData("WHERE TaskBaseCode = '" + str.SubstringByte(taskCode, 1, 6) + "'");
if (dt == null || dt.Rows.Count < 1)
{
DMessage.DataNotExistence("D_Task TaskBaseCode = " + str.SubstringByte(taskCode, 1, 6));
return(null);
}
TaskData td = new TaskData(dt.Rows[0]);
return(td);
}
public TaskCodeNameData[] SelectTaskCodeNameFromCostReport(DateTime dateFr, DateTime dateTo, string scCode, string officeCode)
{
string selParam = "DISTINCT TaskCode FROM D_CostReport WHERE ( ReportDate BETWEEN '" + dateFr + "' AND '" + dateTo + "') "
+ "AND OfficeCode = '" + officeCode + "' AND ";
selParam += scCode[0] == 'F' ? "SubCoCode = " : "ItemCode = ";
selParam += "'" + scCode + "' ORDER BY TaskCode";
SqlHandling sh = new SqlHandling();
DataTable dt = sh.SelectFullDescription(selParam);
if (dt == null || dt.Rows.Count < 1)
{
return(null);
}
string[] taskCdArray = new string[dt.Rows.Count];
DataRow dr;
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
taskCdArray[i] = Convert.ToString(dr["TaskCode"]);
}
StringUtility utl = new StringUtility();
TaskIndData tid = new TaskIndData();
TaskCodeNameData[] tcd = new TaskCodeNameData[taskCdArray.Length];
for (int i = 0; i < taskCdArray.Length; i++)
{
tcd[i] = new TaskCodeNameData();
tcd[i].TaskCode = taskCdArray[i];
tid = tid.SelectTaskIndData(utl.SubstringByte(tcd[i].TaskCode, 2, 3) == "999"
? utl.SubstringByte(tcd[i].TaskCode, 0, 1) + Convert.ToString(DHandling.FisicalYear() - 2000) + utl.SubstringByte(tcd[i].TaskCode, 1, 1) + "999"
: tcd[i].TaskCode);
tcd[i].TaskName = tid.TaskName;
tcd[i].LeaderMCode = tid.LeaderMCode;
}
return(tcd);
}
public int CreateCostReportDataByCSVData(string fileName, string officeCode)
{
int procCount = 0;
int repoDate;
string[] codeArray = new string[2];
int[] getaArray = new int[] { 0, 300000, 500000, 700000 };
int geta = getaArray[Conv.OfficeCodeIndex(officeCode)];
StringUtility sutil = new StringUtility();
MembersData md = new MembersData();
CostReportData crd = new CostReportData();
try
{
using (var streamReader = new StreamReader(fileName, System.Text.Encoding.Default))
{
while (!streamReader.EndOfStream)
{
var line = streamReader.ReadLine();
var valArray = line.Split(',');
if (!DHandling.IsNumeric(Convert.ToString(valArray[0])))
{
continue;
}
if (Convert.ToInt32(valArray[4]) > 900000)
{
continue;
}
crd.SlipNo = Convert.ToInt32(valArray[4]) + geta;
repoDate = (Convert.ToInt32(valArray[1]) == 0) ? Convert.ToInt32(valArray[2]) + 19880000 : Convert.ToInt32(valArray[2]) + 20000000;
crd.ReportDate = DateTime.ParseExact(Convert.ToString(repoDate) + "000000", "yyyyMMddHHmmss", null);
crd.TaskCode = Convert.ToString(valArray[5]);
crd.ItemCode = Convert.ToString(valArray[12]);
crd.Item = Convert.ToString(valArray[14]);
crd.Quantity = Convert.ToDecimal(valArray[18]);
crd.Unit = Convert.ToString(valArray[19]);
crd.UnitPrice = Convert.ToDecimal(valArray[20]);
crd.Cost = Convert.ToDecimal(valArray[21]);
crd.Note = Convert.ToString(valArray[27]);
TaskData td = new TaskData();
td = td.SelectTaskData(crd.TaskCode);
if (td != null)
{
crd.CustoCode = td.PartnerCode;
crd.SalesMCode = td.SalesMCode;
}
crd.Subject = sutil.SubstringByte(crd.ItemCode, 0, 1);
crd.SubCoCode = (crd.Subject == "F") ? crd.ItemCode : "";
crd.MemberCode = (Convert.ToInt32(valArray[9]) < 100) ? "0" + Convert.ToString(valArray[9]) : Convert.ToString(valArray[9]);
crd.LeaderMCode = (Convert.ToInt32(valArray[9]) < 100) ? "0" + Convert.ToString(valArray[9]) : Convert.ToString(valArray[9]);
// 事業所および部門
crd.OfficeCode = officeCode;
crd.Department = (crd.OfficeCode == "H") ? Conv.tdHList[Conv.DepartmentCodeIndex(sutil.SubstringByte(crd.TaskCode, 0, 1))]
: Conv.tdBList[Conv.DepartmentCodeIndex(sutil.SubstringByte(crd.TaskCode, 0, 1))];
if (crd.MemberCode != "" && crd.MemberCode == holdMCode)
{
crd.Department = holdDept;
}
else
{
codeArray = md.SelectMembersOffice(crd.MemberCode);
if (codeArray != null)
{
if (codeArray[0] == crd.OfficeCode)
{
crd.Department = codeArray[1];
}
}
holdMCode = crd.MemberCode;
holdDept = crd.Department;
}
crd.AccountCode = "SYO";
crd.CoTaskCode = "";
if (crd.ExistenceSlipNo())
{
continue;
}
// 項目移送
if (!crd.InsertCostReport())
{
return(0);
}
procCount++;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
procCount = -1;
}
return(procCount);
}
private string editTextLine()
{
// 2018.01 asakawa 数値がマイナスの場合の出力形式の修正のために一部変更
string textLine = "";
// 伝区
textLine += "0";
// 年号
textLine += "1";
// 売上年月日
string date = ReportDate.ToShortDateString();
textLine += util.TruncateByteRight(DHandling.RemoveNoNum(date), 6); // yyyymmdd →yymmdd
// 請求年月日
textLine += util.TruncateByteRight(DHandling.RemoveNoNum(date), 6); // yyyymmdd →yymmdd
// 伝票番号 6桁、0Padding
textLine += util.PaddingInBytes(Convert.ToString(SlipNo), "Number", 6);
// 得意先コード（業務No)
textLine += TaskCode;
// 得意先名
char[] strChar = TaskName.ToCharArray();
for (int i = 0; i < strChar.Length; i++)
{
if (strChar[i] == ' ')
{
strChar[i] = ' ';
}
}
TaskName = new string( strChar );
//string taskData = util.FormFixedByteLengthLeft("(" + CostType + ")" + TaskName, 68);
string taskData = util.FormFixedByteLengthLeft(TaskName, 68);
textLine += util.TruncateByteLeft(taskData, 40);
// 先方担当者名
textLine += util.TruncateByteRight(taskData, 28);
// 部門コード
int dIdx = Array.IndexOf(sdKeyArray, (OfficeCode + util.SubstringByte(TaskCode, 0, 1)));
if (dIdx < 0)
{
dIdx = Array.IndexOf(sdKeyArray, (OfficeCode + " "));
}
textLine += sDeptArray[dIdx];
// 担当者コード
//string pCode = Conv.ResizeMemberCode(MemberCode.TrimEnd(),2);
textLine += Conv.ResizeMemberCode(LeaderMCode.TrimEnd(), 2);
// 摘要コード
textLine += "00";
// 摘要名
textLine += util.PaddingInBytes(" ", "Char", 30);
// 商品コード
textLine += util.SubstringByte(ItemCode, 0, 4);
// マスター区分
textLine += "0";
// 品名
if (ItemCode.TrimEnd() == "K999")
{
char checkChar = ' ';
if (Item != "")
{
checkChar = Item[0];
}
string kItem = (checkChar == '●') ? Item : kMark + Item;
textLine += util.FormFixedByteLengthLeft(kItem, 36);
}
else
{
textLine += util.FormFixedByteLengthLeft(Item, 36);
}
//textLine += util.PaddingInBytes(Item, "Char", 36);
//textLine += util.FormFixedByteLengthLeft(Item, 36);
// 区
textLine += "0";
// 入数
textLine += "0000";
// 箱数
textLine += "00000";
// 数量
if (Quantity == 0)
{
Quantity = 1; // 0では商魂汎用データ作成時にエラーになる
}
// 2018.01 asakawa マイナス値の場合の出力形式の修正のために変更
// textLine += util.PaddingInBytes( Convert.ToString( Quantity ), "Number", 9 );
if (Quantity < 0)
{
textLine += "-";
decimal qq = Quantity * (-1);
textLine += util.PaddingInBytes(Convert.ToString(qq), "Number", 8);
}
else
{
textLine += util.PaddingInBytes(Convert.ToString(Quantity), "Number", 9);
}
// 単位
textLine += util.PaddingInBytes(Unit, "Char", 4);
// 単価
// 2018.01 asakawa マイナス値の場合の出力形式の修正のために変更
// textLine += util.PaddingInBytes( UnitPrice.ToString( "0" ), "Number", 10 );
if (UnitPrice < 0)
{
textLine += "-";
decimal pp = UnitPrice * (-1);
// textLine += util.PaddingInBytes(Convert.ToString(pp), "Number", 9); // 小数点以下も出力される
textLine += util.PaddingInBytes(pp.ToString("0"), "Number", 9);
}
else
{
textLine += util.PaddingInBytes(UnitPrice.ToString("0"), "Number", 10);
}
// 売上金額
int sales = Convert.ToInt32(Quantity * UnitPrice);
// 2018.01 asakawa マイナス値の場合の出力形式の修正のために変更
// textLine += util.PaddingInBytes( Convert.ToString( sales ), "Number", 10 );
if (sales < 0)
{
textLine += "-";
textLine += util.PaddingInBytes(Convert.ToString(sales * (-1)), "Number", 9);
}
else
{
textLine += util.PaddingInBytes(Convert.ToString(sales), "Number", 10);
}
// 原単価
textLine += util.PaddingInBytes("0", "Number", 9);
// 原価額
textLine += util.PaddingInBytes("0", "Number", 10);
// 税区分
textLine += "0";
// 税込区分
textLine += "0";
// 備考区分
textLine += "1"; //備考区分が0:備考は数字、1:文字1
// 備考
textLine += util.PaddingInBytes(" ", "Char", 9);
// 同時入荷区分
textLine += "0";
return(textLine);
}
