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; } }