public ActionResult btnSave_Click(FormCollection values)
{
CFG_CARINFO info = new CFG_CARINFO();
info.ID = Convert.ToInt32(values["Id"]);
info.VEHICLENO = values["VehicleNo"];
info.VEHICLETYPE = Convert.ToInt32(values["VehicleType"]);
info.VEHICLEBRAND = values["VehicleBrand"];
info.BELONGDEPTID = Convert.ToInt32(values["BelongDeptId"]);
info.BELONGNETID = Convert.ToInt32(values["BelongNetId"]);
info.OWNERTYPE = Convert.ToInt32(values["OwnerType"]);
info.REMARK = values["Remark"];
info.OWNER = values["Owner"];
info.CLDWZDSBH = values["Cldwzdsbh"];
info.WLWKHM = values["Wlwkhm"];
var isSuccess = CarBLL.Update(info);
ActiveWindow.HidePostBack();
if (isSuccess)
{
ShowNotify("数据修改成功！");
}
else
{
ShowNotify("数据修改失败！");
}
return(UIHelper.Result());
}
public ActionResult DeleteRows(JArray selectedRows, JArray CarGrid_fields, string vehicleNo, int ownerType, int CarGrid_pageIndex, int CarGrid_pageSize)
{
var ids = new List <int>();
foreach (var id in selectedRows)
{
ids.Add(Convert.ToInt32(id));
}
var isSuccess = CarBLL.Delete(ids.ToArray());
if (isSuccess)
{
ShowNotify("数据删除成功！");
}
else
{
ShowNotify("数据删除失败！");
}
var grid1 = UIHelper.Grid("CarGrid");
var recordCount = 0;
var data = CarBLL.GetList(vehicleNo, ownerType, CarGrid_pageIndex + 1, CarGrid_pageSize, out recordCount);
grid1.RecordCount(recordCount);
grid1.DataSource(data, CarGrid_fields);
return(UIHelper.Result());
}
private void BindData()
{
CarBLL carBL = new CarBLL(connectionString);
CarList.DataSource = carBL.GetCarInventory();
CarList.DataBind();
}
static void Main(string[] args)
{
Car myCar = new CarBLL().GetCarFromDB();
myCar.Go();
myCar.Drift();
}
protected void CarList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int carID = Convert.ToInt32(CarList.DataKeys[e.RowIndex].Value.ToString());
CarBLL carBL = new CarBLL(connectionString);
carBL.DeleteCar(carID);
BindData();
}
private void LoadData()
{
var recordCount = 0;
var data = CarBLL.GetList("", -1, 1, 20, out recordCount);
ViewBag.Grid1RecordCount = recordCount;
ViewBag.Grid1DataSource = data;
}
protected override void WfCreateBoBasic()
{
BoMaster = new AdmBLL(LoginInfo.CompNo, TabMaster.TargetTable, TabMaster.TargetColumn, TabMaster.ViewTable);
BoAdm = new AdmBLL(BoMaster.OfGetConntion());
BoBas = new BasBLL(BoMaster.OfGetConntion());
BoCar = new CarBLL(BoMaster.OfGetConntion());
return;
}
public ActionResult btnCarSearch_Click(JArray CarGrid_fields, string vehicleNo, int ownerType, int CarGrid_pageIndex, int CarGrid_pageSize)
{
var grid1 = UIHelper.Grid("CarGrid");
var recordCount = 0;
var data = CarBLL.GetList(vehicleNo, ownerType, CarGrid_pageIndex + 1, CarGrid_pageSize, out recordCount);
grid1.RecordCount(recordCount);
grid1.DataSource(data, CarGrid_fields);
return(UIHelper.Result());
}
/// <summary>
/// Excel导入Access
/// </summary>
public void Excel2Access(string[] filenames)
{
try
{
for (int j = 0; j < filenames.Length; j++)
{
OleDbConnectionStringBuilder connectStringBuilder = new OleDbConnectionStringBuilder();
connectStringBuilder.DataSource = filenames[j];
connectStringBuilder.Provider = "Microsoft.Jet.Oledb.4.0";
connectStringBuilder.Add("Extended Properties", "Excel 8.0");
using (OleDbConnection cn = new OleDbConnection(connectStringBuilder.ConnectionString))
{
DataSet ds = new DataSet();
string sql = string.Format("select * from [{0}$]", sheetName);
OleDbCommand cmdLiming = new OleDbCommand(sql, cn);
cn.Open();
using (OleDbDataReader dr = cmdLiming.ExecuteReader())
{
ds.Load(dr, LoadOption.OverwriteChanges, new string[] { sheetName });
DataTable dt = ds.Tables[sheetName];
if (dt.Rows.Count > 0)
{
for (int i = 4; i < dt.Rows.Count; i++)
{
//写入数据库数据
if (!(dt.Rows[i][0].ToString() == "" || string.IsNullOrEmpty(dt.Rows[i][0].ToString())))
{
string MySql = "insert into TB_Car (PlateNumber,Color,Brand,UseYear,MotorcyleType) values('" + dt.Rows[i][1].ToString() + "','" +
dt.Rows[i][2].ToString() + "','" + dt.Rows[i][3].ToString() + "','" +
dt.Rows[i][4].ToString() + "','" + dt.Rows[i][5].ToString() + "')";
AccessHelper.SQLExecute(MySql);
}
}
MessageBox.Show("数据导入成功！");
CarBLL carBLL = new CarBLL();
DataTable carList = carBLL.FindAll_infos(getblacklistsql);
dgvCarList.DataSource = carList;
}
else
{
MessageBox.Show("请检查你的Excel中是否存在数据");
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CarBLL bll = new CarBLL(connectionString);
List <CarViewModel> cars = new List <CarViewModel>(bll.GetCarInventory());
foreach (var car in cars)
{
ddlRide.Items.Insert(cars.IndexOf(car), new ListItem(car.Name.ToString(), car.CarID.ToString()));
}
}
}
private void LoadData()
{
var recordCount = 0;
var data = UserBLL.GetList("", "", -1, -1, 1, 20, out recordCount);
ViewBag.UserGridRecordCount = recordCount;
ViewBag.UserGridDataSource = data;
var recordCount1 = 0;
var data1 = CarBLL.GetList("", -1, 1, 20, out recordCount1);
ViewBag.CarGridRecordCount = recordCount1;
ViewBag.CarGridDataSource = data1;
}
public AdminController()
{
_ClientBll = new ClientBLL();
_carBll = new CarBLL();
_contractBll = new ContractBLL();
_employeeBll = new EmployeeBLL();
_serviceBll = new ServiceBLL();
ViewData["Clients"] = _clients;
ViewData["Cars"] = _cars;
ViewData["Contracts"] = _contracts;
ViewData["Employees"] = _employees;
ViewData["Services"] = _services;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CarBLL entity = new CarBLL(connectionString);
List <CarViewModel> CarList = new List <CarViewModel>();
List <string> CarNames = new List <string>();
CarList = entity.GetCarInventory();
foreach (CarViewModel Car in CarList)
{
CarNames.Add(Car.Name.ToString());
}
RideDropDownList.DataSource = CarNames;
RideDropDownList.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CarBLL bll = new CarBLL(connectionString);
CarViewModel car = bll.GetCarById(Convert.ToInt32(Request.QueryString["CarID"]));
Name.Text = car.Name;
Make.Text = car.Make;
Model.Text = car.Model;
Trim.Text = car.Trim;
Year.Text = car.Year.ToString();
Description.Text = car.Description;
CityMPG.Text = car.CityMPG.ToString();
HighwayMPG.Text = car.HighwayMPG.ToString();
IsAutomatic.SelectedValue = car.IsAutomatic.ToString();
HourlyRate.Text = car.HourlyRate.ToString();
YearValidator.MaximumValue = (DateTime.Now.Year + 1).ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CarBLL carBL = new CarBLL(connectionString);
ReportBLL reportBL = new ReportBLL(connectionString);
ReportViewModel report = reportBL.GetReportById(Convert.ToInt32(Request.QueryString["ReportID"]));
List <CarViewModel> cars = new List <CarViewModel>(carBL.GetCarInventory());
foreach (var car in cars)
{
ddlRide.Items.Insert(cars.IndexOf(car), new ListItem(car.Name.ToString(), car.CarID.ToString()));
}
tbIncidentDate.Text = report.DateOfIncident.ToString();
tbReportName.Text = report.ReportName.ToString();
tbDescription.Text = report.ReportDescription;
}
}
protected void CarEditButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
CarBLL bll = new CarBLL(connectionString);
CarViewModel car = new CarViewModel();
car.CarID = Convert.ToInt32(Request.QueryString["CarID"]);
car.Name = Name.Text;
car.Make = Make.Text;
car.Model = Model.Text;
car.Trim = Trim.Text;
car.Year = Convert.ToInt32(Year.Text);
car.Description = Description.Text;
car.CityMPG = Convert.ToInt32(CityMPG.Text);
car.HighwayMPG = Convert.ToInt32(HighwayMPG.Text);
car.IsAutomatic = Convert.ToBoolean(IsAutomatic.SelectedValue);
car.HourlyRate = Convert.ToDouble(HourlyRate.Text);
bll.EditCar(car);
Response.Redirect("~/Cars.aspx");
}
}
protected void CarAddButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
string connectionString = ConfigurationManager.ConnectionStrings["RideXpressConnectionString"].ToString();
CarBLL bll = new CarBLL(connectionString);
CarViewModel car = new CarViewModel();
car.Name = Name.Text;
car.Make = Make.Text;
car.Model = Model.Text;
car.Trim = Trim.Text;
car.Year = Convert.ToInt32(Year.Text);
car.Description = Description.Text;
car.CityMPG = Convert.ToInt32(CityMPG.Text);
car.HighwayMPG = Convert.ToInt32(HighwayMPG.Text);
car.IsAutomatic = Convert.ToBoolean(IsAutomatic.SelectedValue);
car.HourlyRate = Convert.ToDouble(HourlyRate.Text);
bll.AddCar(car);
Response.Redirect("~/Cars.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CarBLL entity = new CarBLL(connectionString);
List <CarViewModel> CarList = new List <CarViewModel>();
List <string> CarNames = new List <string>();
CarList = entity.GetCarInventory();
foreach (CarViewModel Car in CarList)
{
CarNames.Add(Car.Name.ToString());
}
RideDropDownList.DataSource = CarNames;
RideDropDownList.DataBind();
ReportBLL bll = new ReportBLL(connectionString);
ReportViewModel report = bll.GetReportById(Convert.ToInt32(Request.QueryString["ReportID"]));
RideDropDownList.SelectedValue = GetCarName(report.CarID);
DateOfIncident.Text = Convert.ToDateTime(report.DateOfIncident).ToString("yyyy-MM-dd");
ReportName.Text = report.ReportName;
ReportDescription.Text = report.ReportDescription;
}
}
public List <Result> OfGenGeaByCfa(string pCfa01, UserInfo pLoginInfo)
{
List <Result> rtnResultList = null;
Result result = null;
cfa_tb cfaModel = null;
List <cfb_tb> cfbList = null;
string sqlSelect = "";
List <SqlParameter> sqlParmList = null;
CarBLL boCar = null;
StpBLL boStp = null;
BasBLL boBas = null;
DataTable dtGea = null, dtGeb = null;
DataRow drGea = null, drGeb = null;
baa_tb baaModel = null;
try
{
rtnResultList = new List <Result>();
boBas = new BasBLL(this.OfGetConntion());
boBas.TRAN = this.TRAN;
boCar = new CarBLL(this.OfGetConntion());
boCar.TRAN = this.TRAN;
boStp = new StpBLL(this.OfGetConntion());
boStp.TRAN = this.TRAN;
baaModel = boBas.OfGetBaaModel();
if (baaModel == null || GlobalFn.varIsNull(baaModel.baa04))
{
result = new Result();
result.Key1 = pCfa01;
result.Message = "查無本國幣別!";
rtnResultList.Add(result);
return(rtnResultList);
}
cfaModel = boCar.OfGetCfaModel(pCfa01);
if (cfaModel == null)
{
result = new Result();
result.Key1 = pCfa01;
result.Message = "查無此收款沖帳單號!";
rtnResultList.Add(result);
return(rtnResultList);
}
if (cfaModel.cfaconf != "N")
{
result = new Result();
result.Key1 = pCfa01;
result.Message = "收款沖帳單非未確認狀態!";
rtnResultList.Add(result);
return(rtnResultList);
}
cfbList = boCar.OfGetCfbList(pCfa01);
if (cfbList == null || cfbList.Count == 0)
{
result = new Result();
result.Key1 = pCfa01;
result.Message = "收款沖帳單無單身資料!";
rtnResultList.Add(result);
return(rtnResultList);
}
//新增底稿單頭
this.OfCreateDao("gea_tb", "*", "");
sqlSelect = "SELECT * FROM gea_tb WHERE 1<>1 ";
dtGea = this.OfGetDataTable(sqlSelect);
drGea = dtGea.NewRow();
drGea["gea01"] = cfaModel.cfa01; //底稿單號
drGea["gea02"] = "AR"; //系統別
drGea["gea03"] = 2; //1.應收 2.收款
drGea["gea04"] = 1; //AR 固定為1
drGea["gea05"] = cfaModel.cfa02; //同帳款日期
drGea["gea06"] = DBNull.Value; //傳票號碼
drGea["gea07"] = DBNull.Value; //傳票日期
drGea["gea08"] = cfaModel.cfa10; //借方金額--本幣
drGea["gea09"] = cfaModel.cfa11; //貸方金額--本幣
drGea["gea10"] = DBNull.Value; //保留
drGea["gea11"] = DBNull.Value; //保留
drGea["gea12"] = DBNull.Value; //保留
drGea["geaprno"] = 0;
drGea["geacomp"] = pLoginInfo.CompNo;
drGea["geacreu"] = pLoginInfo.UserNo;
drGea["geacreg"] = pLoginInfo.DeptNo;
drGea["geacred"] = OfGetNow();
drGea["geamodu"] = DBNull.Value;
drGea["geamodg"] = DBNull.Value;
drGea["geamodd"] = DBNull.Value;
drGea["geasecu"] = pLoginInfo.UserNo;
drGea["geasecg"] = pLoginInfo.GroupNo;
dtGea.Rows.Add(drGea);
if (this.OfUpdate(dtGea) == -1)
{
result = new Result();
result.Key1 = pCfa01;
result.Message = "新增分錄底稿單頭失敗!";
rtnResultList.Add(result);
return(rtnResultList);
}
//新增底稿單身
this.OfCreateDao("geb_tb", "*", "");
sqlSelect = "SELECT * FROM geb_tb WHERE 1<>1 ";
dtGeb = this.OfGetDataTable(sqlSelect);
//處理貸方資料
foreach (cfb_tb cfbModel in cfbList)
{
drGeb = dtGeb.NewRow();
drGeb["geb01"] = cfbModel.cfb01; //底稿單頭
drGeb["geb02"] = "AR";
drGeb["geb03"] = 2; //1.應收 2.收款
drGeb["geb04"] = 1; //AR 固定為1
drGeb["geb05"] = cfbModel.cfb02; //項次
drGeb["geb06"] = cfbModel.cfb11; //會計科目
drGeb["geb07"] = ""; //摘要
drGeb["geb08"] = cfbModel.cfb13; //部門
drGeb["geb09"] = cfbModel.cfb03; //借貸 1.借 2.貸
drGeb["geb10"] = cfbModel.cfb03; //本幣金額(未稅)
drGeb["geb11"] = cfbModel.cfb07; //原幣幣別
drGeb["geb12"] = cfbModel.cfb08; //匯率
drGeb["geb13"] = cfbModel.cfb09; //原幣金額
drGeb["geb14"] = cfaModel.cfa03; //客戶編號
drGeb["geb15"] = boStp.OfGetSca03(cfaModel.cfa03); //客戶簡稱
drGeb["geb16"] = DBNull.Value; //保留
drGeb["geb17"] = DBNull.Value; //保留
drGeb["geb18"] = DBNull.Value; //保留
drGeb["geb19"] = DBNull.Value; //保留
drGeb["geb20"] = DBNull.Value; //保留
drGeb["geb21"] = DBNull.Value; //保留
drGeb["gebcomp"] = pLoginInfo.CompNo;
drGeb["gebcreu"] = pLoginInfo.UserNo;
drGeb["gebcreg"] = pLoginInfo.DeptNo;
drGeb["gebcred"] = OfGetNow();
drGeb["gebmodu"] = DBNull.Value;
drGeb["gebmodg"] = DBNull.Value;
drGeb["gebmodd"] = DBNull.Value;
dtGeb.Rows.Add(drGeb);
}
if (this.OfUpdate(dtGeb) == -1)
{
result = new Result();
result.Key1 = pCfa01;
result.Message = "新增分錄底稿單身失敗!";
rtnResultList.Add(result);
return(rtnResultList);
}
return(rtnResultList);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult CarDetail()
{
var id = Convert.ToInt32(Request.QueryString["id"]);
#region 拉框绑定
var belongDeptList = CodeBLL.GetCodeListByParentCode("PCS");
var listItems = new List <ListItem>();
foreach (var d in belongDeptList)
{
listItems.Add(new ListItem
{
Text = d.BMVALUE,
Value = d.BMKEY.ToString()
});
}
var belongDept = new DropDownListModel();
belongDept.DropDownList = "VALUE";
belongDept.DropDownListItem = listItems;
var vehicleTypeList = CodeBLL.GetCodeListByParentCode("CLLX");
listItems = new List <ListItem>();
foreach (var d in vehicleTypeList)
{
listItems.Add(new ListItem
{
Text = d.BMVALUE,
Value = d.BMKEY.ToString()
});
}
var vehicleType = new DropDownListModel();
vehicleType.DropDownList = "VALUE1";
vehicleType.DropDownListItem = listItems;
var belongNetList = NetManageBLL.GetAll();
listItems = new List <ListItem>();
foreach (var d in belongNetList)
{
listItems.Add(new ListItem
{
Text = d.Name,
Value = d.Id.ToString()
});
}
var belongNet = new DropDownListModel();
belongNet.DropDownList = "VALUE2";
belongNet.DropDownListItem = listItems;
var ownerTypeList = CodeBLL.GetCodeListByParentCode("YCBM");
listItems = new List <ListItem>();
foreach (var d in ownerTypeList)
{
listItems.Add(new ListItem
{
Text = d.BMVALUE,
Value = d.BMKEY.ToString()
});
}
var ownerType = new DropDownListModel();
ownerType.DropDownList = "VALUE3";
ownerType.DropDownListItem = listItems;
#endregion
CarInfoModel model = new CarInfoModel();
model.belongDept = belongDept;
model.vehicleType = vehicleType;
model.belongNet = belongNet;
model.ownerType = ownerType;
var data = CarBLL.GetByVehId(id);
model.carInfo.Id = data.Id;
model.carInfo.VehicleNo = data.VehicleNo;
model.carInfo.VehicleType = data.VehicleType;
model.carInfo.VehicleBrand = data.VehicleBrand;
model.carInfo.BelongDeptId = data.BelongDeptId;
model.carInfo.BelongNetId = data.BelongNetId;
model.carInfo.Owner = data.Owner;
model.carInfo.OwnerType = data.OwnerType;
model.carInfo.Remark = data.Remark;
model.carInfo.Cldwzdsbh = data.Cldwzdsbh;
model.carInfo.Wlwkhm = data.Wlwkhm;
return(View(model));
}
private bool OfGenGea(vw_carb110 pCarb110Model, sga_tb pSgaModel, Result pResult)
{
string selectSql = "", updateSql = "";
List <SqlParameter> sqlParmList = null;
StpBLL boStp = null;
CarBLL boCar = null;
BasBLL boBas = null;
DataTable dtCea = null, dtCeb = null;
DataRow drCea = null, drCeb = null;
string cea01 = "", cea01New = "";
DateTime? cea02;
string errMsg = "";
List <sgb_tb> sgbList = null;
cac_tb cacModel = null; //收款單別
bab_tb babModel = null; //出貨單別
int chkCnts = 0;
try
{
boCar = new CarBLL(OfGetConntion());
boCar.TRAN = this.TRAN;
boStp = new StpBLL(OfGetConntion());
boStp.TRAN = this.TRAN;
boBas = new BasBLL(OfGetConntion());
boBas.TRAN = this.TRAN;
boCar.OfCreateDao("cea_tb", "*", "");
selectSql = @"SELECT * FROM cea_tb WHERE 1<>1";
dtCea = boCar.OfGetDataTable(selectSql);
drCea = dtCea.NewRow();
//已輸入的為主
if (!GlobalFn.varIsNull(pCarb110Model.cea01))
{
cea01 = pCarb110Model.cea01;
}
else
{
//以出貨單別設定的來拋轉
babModel = boBas.OfGetBabModel(pSgaModel.sga01);
if (babModel == null)
{
pResult.Key1 = pSgaModel.sga01;
pResult.Message = "取得出貨單別失敗!";
return(false);
}
if (GlobalFn.varIsNull(babModel.bab09))
{
pResult.Key1 = pSgaModel.sga01;
pResult.Message = "未設定出貨單拋轉應收帳款單別,請先至單別資料設定!";
return(false);
}
cea01 = babModel.bab09;
}
if (!GlobalFn.varIsNull(pCarb110Model.cea02))
{
cea02 = pCarb110Model.cea02;
}
else
{
cea02 = pSgaModel.sga02;
}
errMsg = "";
if (boBas.OfGetAutoNo(cea01, ModuleType.car, (DateTime)cea02, out cea01New, out errMsg) == false)
{
pResult.Key1 = pSgaModel.sga01;
pResult.Message = errMsg;
return(false);
}
drCea["cea00"] = "11"; //帳款類別
drCea["cea01"] = cea01New;
drCea["cea02"] = cea02;
drCea["cea03"] = pSgaModel.sga03;
drCea["cea04"] = pSgaModel.sga04;
drCea["cea05"] = pSgaModel.sga05; //業務部門
drCea["cea06"] = pSgaModel.sga06; //課稅別
drCea["cea07"] = pSgaModel.sga07; //稅率
drCea["cea08"] = pSgaModel.sga08; //含稅否
drCea["cea09"] = pSgaModel.sga09; //發票聯數
drCea["cea10"] = pSgaModel.sga10; //幣別
drCea["cea11"] = pSgaModel.sga11; //收款條件
drCea["cea12"] = pSgaModel.sga21; //匯率
drCea["cea13"] = pSgaModel.sga13; //原幣未稅金額
drCea["cea13t"] = pSgaModel.sga13t; //原幣含稅金額
drCea["cea13g"] = pSgaModel.sga13g; //原幣稅額
drCea["cea14"] = 0; //原幣沖帳金額
drCea["cea15"] = 0; //本幣未稅金額
drCea["cea15t"] = 0; //本幣含稅金額
drCea["cea15g"] = 0; //本幣稅額
drCea["cea16"] = 0; //本幣沖帳金額
drCea["cea17"] = ""; //參考單號
drCea["cea18"] = ""; //備註
drCea["cea19"] = DBNull.Value; //應收款日
drCea["cea20"] = ""; //保留
drCea["cea21"] = ""; //科目類別
drCea["cea22"] = ""; //會科編號
drCea["cea23"] = ""; //發票別
drCea["cea24"] = ""; //發票日期
drCea["cea25"] = ""; //發票號碼
drCea["cea26"] = ""; //發票客戶
drCea["cea27"] = ""; //申報統編
drCea["cea28"] = ""; //來源別
drCea["cea29"] = ""; //傳票編號
drCea["ceaconf"] = "N";
drCea["ceacomp"] = _loginInfo.CompNo;
drCea["ceacreu"] = _loginInfo.UserNo;
drCea["ceacreg"] = _loginInfo.DeptNo;
drCea["ceacred"] = OfGetNow();
drCea["ceamodu"] = DBNull.Value;
drCea["ceamodg"] = DBNull.Value;
drCea["ceamodd"] = DBNull.Value;
drCea["ceasecu"] = _loginInfo.UserNo;
drCea["ceasecg"] = _loginInfo.GroupNo;
dtCea.Rows.Add(drCea);
if (boCar.OfUpdate(dtCea) == -1)
{
pResult.Key1 = cea01New;
pResult.Message = "新增應收單頭失敗!";
return(false);
}
boCar.OfCreateDao("cfb_tb", "*", "");
selectSql = @"SELECT * FROM ceb_tb WHERE 1<>1";
dtCeb = boCar.OfGetDataTable(selectSql);
foreach (sgb_tb sgbModel in sgbList.OrderBy(p => p.sgb02))
{
drCeb = dtCeb.NewRow();
drCeb["ceb00"] = "11"; //帳款類別
drCeb["ceb01"] = cea01New; //傳票編號
drCeb["ceb02"] = sgbModel.sgb02; //項次
drCeb["ceb03"] = sgbModel.sgb03; //料號
drCeb["ceb04"] = sgbModel.sgb04; //品名
drCeb["ceb05"] = sgbModel.sgb05; //數量
drCeb["ceb06"] = sgbModel.sgb09; //原幣單價
drCeb["ceb07"] = sgbModel.sgb10; //原幣未稅金額
drCeb["ceb07t"] = sgbModel.sgb10t; //原幣含稅金額
drCeb["ceb08"] = 0; //本幣單價
drCeb["ceb09"] = 0; //本未稅金額
drCeb["ceb09t"] = 0; //本幣含稅金額
drCeb["ceb10"] = ""; //會計科目
drCeb["ceb11"] = pSgaModel.sga01; //出貨單號
drCeb["ceb12"] = sgbModel.sgb02; //出貨項次
drCeb["ceb13"] = 0; //原幣已沖金額
drCeb["ceb14"] = 0; //本幣已沖金額
drCeb["ceb15"] = 0; //本幣未沖金額
drCeb["ceb16"] = sgbModel.sgb06; //單位
drCeb["cebcomp"] = _loginInfo.CompNo;
drCeb["cebcreu"] = _loginInfo.UserNo;
drCeb["cebcreg"] = _loginInfo.DeptNo;
drCeb["cebcred"] = OfGetNow();
drCeb["cebmodu"] = DBNull.Value;
drCeb["cebmodg"] = DBNull.Value;
drCeb["cebmodd"] = DBNull.Value;
dtCeb.Rows.Add(drCeb);
}
if (boCar.OfUpdate(dtCeb) == -1)
{
pResult.Key1 = cea01New;
pResult.Message = "新增應收單身失敗!";
return(false);
}
updateSql = @"UPDATE sga_tb
SET sga22=@sga22
WHERE sga01=@sga01
";
sqlParmList = new List <SqlParameter>();
sqlParmList.Add(new SqlParameter("@sga22", cea01New));
sqlParmList.Add(new SqlParameter("@sga01", pSgaModel.sga01));
chkCnts = OfExecuteNonquery(updateSql, sqlParmList.ToArray());
if (chkCnts != 1)
{
pResult.Key1 = pSgaModel.sga01;
pResult.Message = "更新出貨單失敗!";
return(false);
}
// updateSql = @"UPDATE gea_tb
// SET gea06=@gea06,
// gea07=@gea07
// WHERE gea01=@gea01
// AND gea02=@gea02
// AND gea03=@gea03
// AND gea04=@gea04
// ";
// sqlParmList = new List<SqlParameter>();
// sqlParmList.Add(new SqlParameter("@gea06", cea01New));
// sqlParmList.Add(new SqlParameter("@gea07", cea02));
// sqlParmList.Add(new SqlParameter("@gea01", pGeaModel.gea01));
// sqlParmList.Add(new SqlParameter("@gea02", pGeaModel.gea02));
// sqlParmList.Add(new SqlParameter("@gea03", pGeaModel.gea03));
// sqlParmList.Add(new SqlParameter("@gea04", pGeaModel.gea04));
// chkCnts = OfExecuteNonquery(updateSql, sqlParmList.ToArray());
// if (chkCnts != 1)
// {
// pResult.Key1 = pGeaModel.gea01;
// pResult.Message = "更新分稿底稿失敗!";
// return false;
// }
return(true);
}
catch (Exception ex)
{
pResult.Key1 = pSgaModel.sga01;
pResult.Message = ex.Message;
pResult.Exception = ex;
throw;
}
}
public int GetCarId(string carName)
{
CarBLL entity = new CarBLL(connectionString);
return(entity.GetIdByCarName(carName).CarID);
}
public string GetCarName(int carID)
{
CarBLL entity = new CarBLL(connectionString);
return(entity.GetCarInventory().Where(x => x.CarID == carID).Select(x => x.Name).FirstOrDefault());
}
public List <Result> OfGenGeaByCea(string pCea01, UserInfo pLoginInfo)
{
List <Result> rtnResultList = null;
Result result = null;
cea_tb ceaModel = null;
List <ceb_tb> cebList = null;
string sqlSelect = "";
List <SqlParameter> sqlParmList = null;
CarBLL boCar = null;
StpBLL boStp = null;
BasBLL boBas = null;
DataTable dtGea = null, dtGeb = null;
DataRow drGea = null, drGeb = null;
decimal gea08 = 0, gea09 = 0;
int i;
baa_tb baaModel = null;
gba_tb gbaModel = null;
cba_tb cbaModel = null;
try
{
rtnResultList = new List <Result>();
boBas = new BasBLL(this.OfGetConntion());
boBas.TRAN = this.TRAN;
boCar = new CarBLL(this.OfGetConntion());
boCar.TRAN = this.TRAN;
boStp = new StpBLL(this.OfGetConntion());
boStp.TRAN = this.TRAN;
baaModel = boBas.OfGetBaaModel();
if (baaModel == null || GlobalFn.varIsNull(baaModel.baa04))
{
result = new Result();
result.Key1 = pCea01;
result.Message = "查無本國幣別!";
rtnResultList.Add(result);
return(rtnResultList);
}
ceaModel = boCar.OfGetCeaModel(pCea01);
if (ceaModel == null)
{
result = new Result();
result.Key1 = pCea01;
result.Message = "查無此應收單號!";
rtnResultList.Add(result);
return(rtnResultList);
}
if (ceaModel.ceaconf != "N")
{
result = new Result();
result.Key1 = pCea01;
result.Message = "應收帳款非未確認狀態!";
rtnResultList.Add(result);
return(rtnResultList);
}
cbaModel = boCar.OfGetCbaModel(ceaModel.cea21);
if (cbaModel == null)
{
result = new Result();
result.Key1 = pCea01;
result.Message = "查無應收科目類別資料!";
rtnResultList.Add(result);
return(rtnResultList);
}
if (GlobalFn.varIsNull(cbaModel.cba05))
{
result = new Result();
result.Key1 = pCea01;
result.Message = "查無銷項稅額科目!";
rtnResultList.Add(result);
return(rtnResultList);
}
cebList = boCar.OfGetCebList(pCea01);
if (cebList == null || cebList.Count == 0)
{
result = new Result();
result.Key1 = pCea01;
result.Message = "應收帳款無單身資料!";
rtnResultList.Add(result);
return(rtnResultList);
}
//新增底稿單頭
this.OfCreateDao("gea_tb", "*", "");
sqlSelect = "SELECT * FROM gea_tb WHERE 1<>1 ";
dtGea = this.OfGetDataTable(sqlSelect);
drGea = dtGea.NewRow();
drGea["gea01"] = ceaModel.cea01; //底稿單號
drGea["gea02"] = "AR"; //系統別
drGea["gea03"] = 1; //1.應收 2.收款
drGea["gea04"] = 1; //AR 固定為1
drGea["gea05"] = ceaModel.cea02; //同帳款日期
drGea["gea06"] = DBNull.Value; //傳票號碼
drGea["gea07"] = DBNull.Value; //傳票日期
drGea["gea08"] = ceaModel.cea15t; //借方金額
var ceb09t_tot = cebList.Sum(p => p.ceb09t);
drGea["gea09"] = ceb09t_tot; //貸方金額
drGea["gea10"] = DBNull.Value; //保留
drGea["gea11"] = DBNull.Value; //保留
drGea["gea12"] = DBNull.Value; //保留
drGea["geaprno"] = 0;
drGea["geacomp"] = pLoginInfo.CompNo;
drGea["geacreu"] = pLoginInfo.UserNo;
drGea["geacreg"] = pLoginInfo.DeptNo;
drGea["geacred"] = OfGetNow();
drGea["geamodu"] = DBNull.Value;
drGea["geamodg"] = DBNull.Value;
drGea["geamodd"] = DBNull.Value;
drGea["geasecu"] = pLoginInfo.UserNo;
drGea["geasecg"] = pLoginInfo.GroupNo;
dtGea.Rows.Add(drGea);
if (this.OfUpdate(dtGea) == -1)
{
result = new Result();
result.Key1 = pCea01;
result.Message = "新增分錄底稿單頭失敗!";
rtnResultList.Add(result);
return(rtnResultList);
}
//新增底稿單身
this.OfCreateDao("geb_tb", "*", "");
sqlSelect = "SELECT * FROM geb_tb WHERE 1<>1 ";
dtGeb = this.OfGetDataTable(sqlSelect);
//借方帶單頭應收帳款
//用本幣匯總成一筆來加總
drGeb = dtGeb.NewRow();
i = 1;
drGeb = dtGeb.NewRow();
drGeb["geb01"] = ceaModel.cea01; //底稿單頭
drGeb["geb02"] = "AR";
drGeb["geb03"] = 1; //1.應收 2.收款
drGeb["geb04"] = 1; //AR 固定為1
drGeb["geb05"] = i; //項次
drGeb["geb06"] = ceaModel.cea22; //會計科目-待補入
drGeb["geb07"] = ""; //摘要
drGeb["geb08"] = DBNull.Value; //部門
if (!GlobalFn.varIsNull(ceaModel.cea22))
{
gbaModel = OfGetGbaModel(ceaModel.cea22);
if (gbaModel != null && gbaModel.gba09 == "Y")
{
drGeb["geb08"] = ceaModel.cea05;
}
}
drGeb["geb09"] = 1; //借貸 1.借 2.貸
drGeb["geb10"] = ceaModel.cea15t; //本幣金額(稅)
//幣別均以本幣處理
drGeb["geb11"] = baaModel.baa04; //原幣幣別(帶入本幣幣別)
drGeb["geb12"] = ceaModel.cea12; //匯率
drGeb["geb13"] = ceaModel.cea15t; //原幣金額(稅)
drGeb["geb14"] = ceaModel.cea03; //客戶編號
drGeb["geb15"] = boStp.OfGetSca03(ceaModel.cea03); //客戶簡稱
drGeb["geb16"] = DBNull.Value; //保留
drGeb["geb17"] = DBNull.Value; //保留
drGeb["geb18"] = DBNull.Value; //保留
drGeb["geb19"] = DBNull.Value; //保留
drGeb["geb20"] = DBNull.Value; //保留
drGeb["geb21"] = DBNull.Value; //保留
drGeb["gebcomp"] = pLoginInfo.CompNo;
drGeb["gebcreu"] = pLoginInfo.UserNo;
drGeb["gebcreg"] = pLoginInfo.DeptNo;
drGeb["gebcred"] = OfGetNow();
drGeb["gebmodu"] = DBNull.Value;
drGeb["gebmodg"] = DBNull.Value;
drGeb["gebmodd"] = DBNull.Value;
dtGeb.Rows.Add(drGeb);
//處理貸方未稅明細資料
foreach (ceb_tb cebModel in cebList)
{
i++;
drGeb = dtGeb.NewRow();
drGeb["geb01"] = cebModel.ceb01; //底稿單頭
drGeb["geb02"] = "AR";
drGeb["geb03"] = 1; //1.應收 2.收款
drGeb["geb04"] = 1; //AR 固定為1
drGeb["geb05"] = i; //項次
drGeb["geb06"] = cebModel.ceb10; //會計科目
drGeb["geb07"] = ""; //摘要
drGeb["geb08"] = DBNull.Value; //部門
if (!GlobalFn.varIsNull(cebModel.ceb10))
{
gbaModel = OfGetGbaModel(cebModel.ceb10);
if (gbaModel != null && gbaModel.gba09 == "Y")
{
drGeb["geb08"] = ceaModel.cea05;
}
}
drGeb["geb09"] = 2; //借貸 1.借 2.貸
drGeb["geb10"] = cebModel.ceb09; //本幣金額(未稅)
drGeb["geb11"] = ceaModel.cea10; //原幣幣別
drGeb["geb12"] = ceaModel.cea12; //匯率
drGeb["geb13"] = cebModel.ceb07; //原幣金額
drGeb["geb14"] = ceaModel.cea03; //客戶編號
drGeb["geb15"] = boStp.OfGetSca03(ceaModel.cea03); //客戶簡稱
drGeb["geb16"] = DBNull.Value; //保留
drGeb["geb17"] = DBNull.Value; //保留
drGeb["geb18"] = DBNull.Value; //保留
drGeb["geb19"] = DBNull.Value; //保留
drGeb["geb20"] = DBNull.Value; //保留
drGeb["geb21"] = DBNull.Value; //保留
drGeb["gebcomp"] = pLoginInfo.CompNo;
drGeb["gebcreu"] = pLoginInfo.UserNo;
drGeb["gebcreg"] = pLoginInfo.DeptNo;
drGeb["gebcred"] = OfGetNow();
drGeb["gebmodu"] = DBNull.Value;
drGeb["gebmodg"] = DBNull.Value;
drGeb["gebmodd"] = DBNull.Value;
dtGeb.Rows.Add(drGeb);
}
//貸方再補一筆稅額
//用本幣匯總成一筆來加總
drGeb = dtGeb.NewRow();
i++;
drGeb = dtGeb.NewRow();
drGeb["geb01"] = ceaModel.cea01; //底稿單頭
drGeb["geb02"] = "AR";
drGeb["geb03"] = 1; //1.應收 2.收款
drGeb["geb04"] = 1; //AR 固定為1
drGeb["geb05"] = i; //項次
drGeb["geb06"] = cbaModel.cba05; //會計科目
drGeb["geb07"] = ""; //摘要
drGeb["geb08"] = DBNull.Value; //部門
if (!GlobalFn.varIsNull(cbaModel.cba05))
{
gbaModel = OfGetGbaModel(cbaModel.cba05);
if (gbaModel != null && gbaModel.gba09 == "Y")
{
drGeb["geb08"] = ceaModel.cea05;
}
}
drGeb["geb09"] = 2; //借貸 1.借 2.貸
var taxTotal = cebList.Sum(x => x.ceb09t - x.ceb09);
drGeb["geb10"] = taxTotal; //本幣金額(稅)
//幣別均以本幣處理
drGeb["geb11"] = baaModel.baa04; //原幣幣別(帶入本幣幣別)
drGeb["geb12"] = ceaModel.cea12; //匯率
drGeb["geb13"] = taxTotal; //原幣金額(稅)
drGeb["geb14"] = ceaModel.cea03; //客戶編號
drGeb["geb15"] = boStp.OfGetSca03(ceaModel.cea03); //客戶簡稱
drGeb["geb16"] = DBNull.Value; //保留
drGeb["geb17"] = DBNull.Value; //保留
drGeb["geb18"] = DBNull.Value; //保留
drGeb["geb19"] = DBNull.Value; //保留
drGeb["geb20"] = DBNull.Value; //保留
drGeb["geb21"] = DBNull.Value; //保留
drGeb["gebcomp"] = pLoginInfo.CompNo;
drGeb["gebcreu"] = pLoginInfo.UserNo;
drGeb["gebcreg"] = pLoginInfo.DeptNo;
drGeb["gebcred"] = OfGetNow();
drGeb["gebmodu"] = DBNull.Value;
drGeb["gebmodg"] = DBNull.Value;
drGeb["gebmodd"] = DBNull.Value;
dtGeb.Rows.Add(drGeb);
if (this.OfUpdate(dtGeb) == -1)
{
result = new Result();
result.Key1 = pCea01;
result.Message = "新增分錄底稿單身失敗!";
rtnResultList.Add(result);
return(rtnResultList);
}
return(rtnResultList);
}
catch (Exception ex)
{
throw ex;
}
}
