public CostData SelectCostMaster(string memberCode, string officeCode, string subject)
{
SqlHandling sh = new SqlHandling("M_Cost");
DataTable dt = sh.SelectAllData("WHERE MemberCode = '" + memberCode + "' AND OfficeCode = '" + officeCode + "' AND CostCode LIKE '" + subject + "%'");
if (dt == null || dt.Rows.Count < 1)
{
return(null);
}
CostData cd = new CostData(dt.Rows[0]);
return(cd);
}
public CostData SelectCostMaster(string wParam)
{
SqlHandling sh = new SqlHandling("M_Cost");
DataTable dt = sh.SelectAllData("WHERE " + wParam);
if (dt == null || dt.Rows.Count < 1)
{
return(null);
}
CostData cd = new CostData(dt.Rows[0]);
return(cd);
}
public CostData SelectCostMaster(string costCode, string officeCode)
{
SqlHandling sh = new SqlHandling("M_Cost");
DataTable dt = sh.SelectAllData("WHERE CostCode = '" + costCode + "' AND OfficeCode = '" + officeCode + "'");
if (dt == null || dt.Rows.Count < 1)
{
return(null);
}
CostData cd = new CostData(dt.Rows[0]);
return(cd);
}
//--------------------------------------------------------//
// Method
//--------------------------------------------------------//
public object Clone()
{
CostData cloneData = new CostData();
cloneData.CostID = this.CostID;
cloneData.CostCode = this.CostCode;
cloneData.Item = this.Item;
cloneData.ItemDetail = this.ItemDetail;
cloneData.Unit = this.Unit;
cloneData.Cost = this.Cost;
cloneData.OfficeCode = this.OfficeCode;
cloneData.MemberCode = this.MemberCode;
return(cloneData);
}
private CostData[] createCostDataArray(string wParam)
{
SqlHandling sh = new SqlHandling("M_Cost");
DataTable dt = sh.SelectAllData(wParam);
if (dt == null || dt.Rows.Count < 1)
{
return(null);
}
CostData[] cmd = new CostData[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
cmd[i] = new CostData(dt.Rows[i]);
}
return(cmd);
}
public CostData[] SelectCostDataJoinOsWkReport(string officeCode)
{
SqlHandling sh = new SqlHandling();
DataTable dt = sh.SelectFullDescription("DISTINCT WR.PartnerCode AS CostCode, MC.CostID AS CostID, MC.Item AS Item, "
+ "MC.ItemDetail AS ItemDetail, MC.Unit AS Unit, MC.Cost AS Cost, "
+ "MC.OfficeCode AS OfficeCode, MC.MemberCode AS MemberCode "
+ "FROM M_Cost MC INNER JOIN D_OsWkReport WR ON MC.CostCode = WR.PartnerCode "
+ "WHERE MC.OfficeCode = '" + officeCode + "' AND "
+ "WR.PartnerCode BETWEEN 'F001' AND 'F998' ORDER BY WR.PartnerCode");
if (dt == null || dt.Rows.Count < 1)
{
return(null);
}
CostData[] cmd = new CostData[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
cmd[i] = new CostData(dt.Rows[i]);
}
return(cmd);
}
public int CreateExportCostMaster(string encName, string fileName)
{
int procCnt = 0;
if (dt == null)
{
return(-1);
}
Encoding sjisEnc = Encoding.GetEncoding("Shift_JIS");
using (StreamWriter writer = new StreamWriter(fileName, false, sjisEnc))
{
for (int i = 0; i < dt.Rows.Count; i++)
{
cmd = new CostData(dt.Rows[i]);
writer.WriteLine(editCostMasterLine());
procCnt++;
}
writer.Close();
}
return(procCnt);
}
public CostData[] SelectCostDataFromCostReport(DateTime dateFr, DateTime dateTo, string officeCode, string department)
{
SqlHandling sh = new SqlHandling();
DataTable dt = sh.SelectFullDescription("DISTINCT ItemCode FROM D_CostReport WHERE (ReportDate BETWEEN '" + dateFr + "' AND '" + dateTo
+ "') AND OfficeCode = '" + officeCode + "' AND Department = '" + department
+ "' AND ItemCode LIKE 'A%' ORDER BY ItemCode");
string[] itemArray = new string[1];
int itemCnt = 0;
if (dt != null && dt.Rows.Count > 0)
{
itemArray = new string[dt.Rows.Count];
itemCnt = dt.Rows.Count;
DataRow dr;
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
itemArray[i] = Convert.ToString(dr["ItemCode"]);
}
}
dt = sh.SelectFullDescription("DISTINCT SubCoCode FROM D_CostReport WHERE (ReportDate BETWEEN '" + dateFr + "' AND '" + dateTo
+ "') AND OfficeCode = '" + officeCode + "' AND Department = '" + department
+ "' AND SubCoCode BETWEEN 'F001' AND 'F998' ORDER BY SubCoCode");
string[] subCoArray = new string[1];
int subCoCnt = 0;
if (dt != null && dt.Rows.Count > 0)
{
subCoArray = new string[dt.Rows.Count];
subCoCnt = dt.Rows.Count;
DataRow dr;
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
subCoArray[i] = Convert.ToString(dr["SubCoCode"]);
}
}
if ((itemCnt + subCoCnt) == 0)
{
return(null);
}
string[] costCodeArray = new string[itemCnt + subCoCnt];
if (itemCnt == 0)
{
Array.Copy(subCoArray, costCodeArray, subCoCnt);
}
else
{
Array.Copy(itemArray, costCodeArray, itemCnt);
if (subCoCnt != 0)
{
Array.Copy(subCoArray, 0, costCodeArray, itemCnt, subCoCnt);
}
}
CostData cd = new CostData();
CostData[] cmd = new CostData[costCodeArray.Length];
for (int i = 0; i < costCodeArray.Length; i++)
{
cmd[i] = new CostData();
cmd[i].CostCode = costCodeArray[i];
cmd[i].Item = cd.SelectCostName(cmd[i].CostCode);
}
return(cmd);
}