/// <summary> /// 增加一条数据 /// </summary> public int AddMarketingFeesInfo(MarketingFeesInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tbMarketingFeesInfo("); strSql.Append("StoresID,FeesSubjectID,mRemark,mFees,mDateTime,mType,StaffID,mAppendTime,mIsIncomeExpenditure)"); strSql.Append(" values ("); strSql.Append("@StoresID,@FeesSubjectID,@mRemark,@mFees,@mDateTime,@mType,@StaffID,@mAppendTime,@mIsIncomeExpenditure)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@StoresID", SqlDbType.Int, 4), new SqlParameter("@FeesSubjectID", SqlDbType.Int, 4), new SqlParameter("@mRemark", SqlDbType.VarChar, 1024), new SqlParameter("@mFees", SqlDbType.Money, 8), new SqlParameter("@mDateTime", SqlDbType.DateTime), new SqlParameter("@mType", SqlDbType.Int, 4), new SqlParameter("@StaffID", SqlDbType.Int, 4), new SqlParameter("@mAppendTime", SqlDbType.DateTime), new SqlParameter("@mIsIncomeExpenditure", SqlDbType.Int, 4) }; parameters[0].Value = model.StoresID; parameters[1].Value = model.FeesSubjectID; parameters[2].Value = model.mRemark; parameters[3].Value = model.mFees; parameters[4].Value = model.mDateTime; parameters[5].Value = model.mType; parameters[6].Value = model.StaffID; parameters[7].Value = model.mAppendTime; parameters[8].Value = model.mIsIncomeExpenditure; object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void UpdateMarketingFeesInfo(MarketingFeesInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tbMarketingFeesInfo set "); strSql.Append("StoresID=@StoresID,"); strSql.Append("FeesSubjectID=@FeesSubjectID,"); strSql.Append("mRemark=@mRemark,"); strSql.Append("mFees=@mFees,"); strSql.Append("mDateTime=@mDateTime,"); strSql.Append("mType=@mType,"); strSql.Append("StaffID=@StaffID,"); strSql.Append("mIsIncomeExpenditure=@mIsIncomeExpenditure,"); strSql.Append("mAppendTime=@mAppendTime"); strSql.Append(" where MarketingFeesID=@MarketingFeesID "); SqlParameter[] parameters = { new SqlParameter("@MarketingFeesID", SqlDbType.Int, 4), new SqlParameter("@StoresID", SqlDbType.Int, 4), new SqlParameter("@FeesSubjectID", SqlDbType.Int, 4), new SqlParameter("@mRemark", SqlDbType.VarChar, 1024), new SqlParameter("@mFees", SqlDbType.Money, 8), new SqlParameter("@mDateTime", SqlDbType.DateTime), new SqlParameter("@mType", SqlDbType.Int, 4), new SqlParameter("@StaffID", SqlDbType.Int, 4), new SqlParameter("@mIsIncomeExpenditure", SqlDbType.Int, 4), new SqlParameter("@mAppendTime", SqlDbType.DateTime) }; parameters[0].Value = model.MarketingFeesID; parameters[1].Value = model.StoresID; parameters[2].Value = model.FeesSubjectID; parameters[3].Value = model.mRemark; parameters[4].Value = model.mFees; parameters[5].Value = model.mDateTime; parameters[6].Value = model.mType; parameters[7].Value = model.StaffID; parameters[8].Value = model.mIsIncomeExpenditure; parameters[9].Value = model.mAppendTime; DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); }
protected virtual void Page_Load(object sender, EventArgs e) { if (this.userid > 0) { if (CheckUserPopedoms("X") || CheckUserPopedoms("6-1")) { Act = HTTPRequest.GetString("Act"); if (Act == "Edit") { MarketingFeesID = Utils.StrToInt(HTTPRequest.GetString("mid"), 0); mi = tbMarketingFeesInfo.GetMarketingFeesInfoModel(MarketingFeesID); } if (ispost) { StoresID = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("StoresID")), 0); FeesSubjectID = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("FeesSubjectID")), 0); mRemark = Utils.ChkSQL(HTTPRequest.GetString("mRemark")); mFees = Utils.StrToFloat(Utils.ChkSQL(HTTPRequest.GetString("mFees")), 0); mDateTime = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("mDateTime"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("mDateTime"))) : DateTime.Now; mType = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("mType")), 0); StaffID = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("StaffID")), 0); mi.StoresID = StoresID; mi.FeesSubjectID = FeesSubjectID; mi.mRemark = mRemark; mi.mFees = decimal.Parse(mFees.ToString()); mi.mDateTime = mDateTime; mi.mType = mType; mi.StaffID = StaffID; if (StoresID > 0 || mType != 0) { if (FeesSubjectID > 0) { if (StaffID > 0) { if (Act == "Add") { mi.mAppendTime = mAppendTime; if (tbMarketingFeesInfo.AddMarketingFeesInfo(mi) > 0) { AddMsgLine("创建成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } else { AddErrLine("创建失败!"); AddScript("window.setTimeout('history.back(1);',1000);"); } } if (Act == "Edit") { try { tbMarketingFeesInfo.UpdateMarketingFeesInfo(mi); AddMsgLine("修改成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } catch (Exception ex) { AddErrLine("修改失败!<br/>" + ex); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } } else { AddErrLine("经办人不能为空!"); AddScript("window.setTimeout('history.back(1);',1000);"); } } else { AddErrLine("费用科目不能为空!"); AddScript("window.setTimeout('history.back(1);',1000);"); } } else { AddErrLine("门店不能为空!"); AddScript("window.setTimeout('history.back(1);',1000);"); } } else { if (Act == "Del") { try { tbMarketingFeesInfo.DeleteMarketingFeesInfo(HTTPRequest.GetString("mid")); AddMsgLine("删除成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } catch (Exception ex) { AddErrLine("删除失败!<br/>" + ex); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } } } else { AddErrLine("权限不足!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } else { AddErrLine("请先登录!"); SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); } }
protected virtual void Page_Load(object sender, EventArgs e) { if (this.userid > 0) { if (CheckUserPopedoms("X") || CheckUserPopedoms("6-1")) { Act = HTTPRequest.GetString("Act"); if (ispost) { if (Act == "OK") { loop_count = HTTPRequest.GetInt("loop_count_obj", 0); if (loop_count > 0) { int ObjType = HTTPRequest.GetInt("ObjType", 0); //收入=0,支出=1 int ObjTypeB = HTTPRequest.GetInt("ObjTypeB", 0); //销售费用=0,公司费用=1 int StoresID = 0; //门店 int FeesSubjectID = 0; //科目 int StaffID = 0; //人员 DateTime mDateTime = DateTime.Now; //发生时间 decimal mFees = 0; //金额 string mRemark = ""; //备注 int tCount = 0; MarketingFeesInfo mi = new MarketingFeesInfo(); for (int i = 0; i < loop_count; i++) { FeesSubjectID = HTTPRequest.GetInt("FeesSubjectID_" + i, 0); StaffID = HTTPRequest.GetInt("StaffID_" + i, 0); mDateTime = HTTPRequest.GetString("mDateTime_" + i).Trim() != "" ? DateTime.Parse(HTTPRequest.GetString("mDateTime_" + i).Trim()) : DateTime.Now; mFees = Utils.IsNumeric(HTTPRequest.GetString("mFees_" + i)) ? decimal.Parse(HTTPRequest.GetString("mFees_" + i).ToString()) : 0; mRemark = HTTPRequest.GetString("mRemark_" + i); if (FeesSubjectID > 0 && StaffID > 0) { if (ObjType == 1 && ObjTypeB == 0) { StoresID = HTTPRequest.GetInt("StoresID_" + i, 0); mi.mIsIncomeExpenditure = 0; mi.mType = 0; } else if (ObjType == 1 && ObjTypeB == 1) { mi.mIsIncomeExpenditure = 0; StoresID = 0; mi.mType = 1; } else if (ObjType == 0) { StoresID = 0; mi.mType = -1; mi.mIsIncomeExpenditure = 1; } mi.StoresID = StoresID; mi.FeesSubjectID = FeesSubjectID; mi.mRemark = mRemark; mi.mFees = decimal.Parse(mFees.ToString()); mi.mDateTime = mDateTime; mi.StaffID = StaffID; mi.mAppendTime = DateTime.Now; if (tbMarketingFeesInfo.AddMarketingFeesInfo(mi) > 0) { tCount++; } } } AddMsgLine("导入成功,共导入 <b>" + tCount + "</b> 条数据!"); AddScript("window.setTimeout('window.parent.HidBox();',3000);"); } else { AddErrLine("没有任何数据插入!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } } } else { AddErrLine("权限不足!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } else { AddErrLine("请先登录!"); SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); } }
/// <summary> /// 更新一条数据 /// </summary> public static void UpdateMarketingFeesInfo(MarketingFeesInfo model) { DatabaseProvider.GetInstance().UpdateMarketingFeesInfo(model); }
/// <summary> /// 增加一条数据 /// </summary> public static int AddMarketingFeesInfo(MarketingFeesInfo model) { return(DatabaseProvider.GetInstance().AddMarketingFeesInfo(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public MarketingFeesInfo GetMarketingFeesInfoModel(int MarketingFeesID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 MarketingFeesID,StoresID,FeesSubjectID,mRemark,mFees,mDateTime,mType,StaffID,mAppendTime,(select tbStoresInfo.sName from tbStoresInfo where tbStoresInfo.StoresID=tbMarketingFeesInfo.[StoresID]) as StoresName,(select tbFeesSubjectInfo.fName from tbFeesSubjectInfo where tbFeesSubjectInfo.FeesSubjectID=tbMarketingFeesInfo.[FeesSubjectID]) as FeesSubjectName,(select tbStaffInfo.sName from tbStaffInfo where tbStaffInfo.StaffID=tbMarketingFeesInfo.StaffID) as StaffName,mIsIncomeExpenditure from tbMarketingFeesInfo "); strSql.Append(" where MarketingFeesID=@MarketingFeesID "); SqlParameter[] parameters = { new SqlParameter("@MarketingFeesID", SqlDbType.Int, 4) }; parameters[0].Value = MarketingFeesID; MarketingFeesInfo model = new MarketingFeesInfo(); DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["MarketingFeesID"].ToString() != "") { model.MarketingFeesID = int.Parse(ds.Tables[0].Rows[0]["MarketingFeesID"].ToString()); } if (ds.Tables[0].Rows[0]["StoresID"].ToString() != "") { model.StoresID = int.Parse(ds.Tables[0].Rows[0]["StoresID"].ToString()); } if (ds.Tables[0].Rows[0]["FeesSubjectID"].ToString() != "") { model.FeesSubjectID = int.Parse(ds.Tables[0].Rows[0]["FeesSubjectID"].ToString()); } model.mRemark = ds.Tables[0].Rows[0]["mRemark"].ToString(); if (ds.Tables[0].Rows[0]["mFees"].ToString() != "") { model.mFees = decimal.Parse(ds.Tables[0].Rows[0]["mFees"].ToString()); } if (ds.Tables[0].Rows[0]["mDateTime"].ToString() != "") { model.mDateTime = DateTime.Parse(ds.Tables[0].Rows[0]["mDateTime"].ToString()); } if (ds.Tables[0].Rows[0]["mType"].ToString() != "") { model.mType = int.Parse(ds.Tables[0].Rows[0]["mType"].ToString()); } if (ds.Tables[0].Rows[0]["StaffID"].ToString() != "") { model.StaffID = int.Parse(ds.Tables[0].Rows[0]["StaffID"].ToString()); } if (ds.Tables[0].Rows[0]["mIsIncomeExpenditure"].ToString() != "") { model.mIsIncomeExpenditure = int.Parse(ds.Tables[0].Rows[0]["mIsIncomeExpenditure"].ToString()); } if (ds.Tables[0].Rows[0]["mAppendTime"].ToString() != "") { model.mAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["mAppendTime"].ToString()); } model.StoresName = ds.Tables[0].Rows[0]["StoresName"].ToString(); model.FeesSubjectName = ds.Tables[0].Rows[0]["FeesSubjectName"].ToString(); model.StaffName = ds.Tables[0].Rows[0]["StaffName"].ToString(); return(model); } else { return(null); } }
protected virtual void Page_Load(object sender, EventArgs e) { if (this.userid > 0) { if (CheckUserPopedoms("X") || CheckUserPopedoms("6-1")) { if (ispost) { int sType = Utils.StrToInt(HTTPRequest.GetString("sType"), 0); string PathStr = Utils.GetMapPath(config.DataPath.ToString()); string fileExtension = ""; string fileName = ""; string thispath = DateTime.Now.Year + "-" + DateTime.Now.Month; ArrayList filearr = new ArrayList(); int importdata_count = 0; if (!Directory.Exists(PathStr + thispath)) { Directory.CreateDirectory(PathStr + thispath); } //文件上传 HttpFileCollection files = HttpContext.Current.Request.Files; try { if (files.Count > 0) { for (int i = 0; i < files.Count; i++) { HttpPostedFile postedFile = files[i]; fileName = System.IO.Path.GetFileName(postedFile.FileName); if (Utils.ChkSQL(fileName) != "") { fileExtension = System.IO.Path.GetExtension(fileName).ToLower(); if (fileExtension == ".xls") { postedFile.SaveAs(PathStr + thispath + "/" + fileName); filearr.Add(PathStr + thispath + "/" + fileName); } } } } if (filearr.Count > 0) { MarketingFeesInfo mi = new MarketingFeesInfo(); StoresInfo si = new StoresInfo(); FeesSubjectInfo fi = new FeesSubjectInfo(); StaffInfo ft = new StaffInfo(); try { for (int j = 0; j < filearr.Count; j++) { try { DataSet ds = Excels.ExcelToDataTable(filearr[j].ToString()); DataTable dt = new DataTable(); try { dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { mi.mAppendTime = DateTime.Now; if (sType == 0)//营销费用 { if (dr[0].ToString() != "" && dr[1].ToString() != "" && dr[2].ToString() != "" && dr[3].ToString() != "" && dr[4].ToString() != "") { if (Utils.IsNumeric(dr[3].ToString())) { si = tbStoresInfo.GetStoresInfoModelByName(dr[2].ToString().Trim()); if (si == null) { si = tbStoresInfo.GetStoresInfoModelByCode(dr[1].ToString().Trim()); } if (si != null) { mi.StoresID = si.StoresID; } fi = tbFeesSubjectInfo.GetFeesSubjectInfoModelByName(dr[4].ToString().Trim()); if (fi != null) { mi.FeesSubjectID = fi.FeesSubjectID; } mi.mRemark = dr[5].ToString().Trim(); mi.mFees = decimal.Parse(Utils.StrToFloat(dr[3].ToString().Trim(), 0).ToString()); mi.mDateTime = DateTime.Parse(dr[0].ToString().Trim()); mi.mType = 0; mi.StaffID = 0; if (tbMarketingFeesInfo.AddMarketingFeesInfo(mi) > 0) { importdata_count++; } } } } if (sType == 1)//公司费用 { if (dr[0].ToString() != "" && dr[1].ToString() != "" && dr[2].ToString() != "" && dr[3].ToString() != "") { if (Utils.IsNumeric(dr[2].ToString())) { mi.StoresID = 0; mi.mDateTime = DateTime.Parse(dr[0].ToString().Trim()); fi = tbFeesSubjectInfo.GetFeesSubjectInfoModelByName(dr[1].ToString().Trim()); if (fi != null) { mi.FeesSubjectID = fi.FeesSubjectID; } mi.mFees = decimal.Parse(Utils.StrToFloat(dr[2].ToString().Trim(), 0).ToString()); ft = tbStaffInfo.GetStaffInfoModelByName(dr[3].ToString().Trim()); if (ft != null) { mi.StaffID = ft.StaffID; } mi.mType = 1; mi.mRemark = dr[4].ToString().Trim(); if (tbMarketingFeesInfo.AddMarketingFeesInfo(mi) > 0) { importdata_count++; } } } } if (sType == 2)//收入 { if (dr[0].ToString() != "" && dr[1].ToString() != "" && dr[2].ToString() != "") { if (Utils.IsNumeric(dr[1].ToString())) { mi.StoresID = 0; mi.mDateTime = DateTime.Parse(dr[0].ToString().Trim()); if (dr[3].ToString().Trim() != "") { fi = tbFeesSubjectInfo.GetFeesSubjectInfoModelByName(dr[3].ToString().Trim()); if (fi != null) { mi.FeesSubjectID = fi.FeesSubjectID; } } else { mi.FeesSubjectID = 0; } mi.mFees = decimal.Parse(Utils.StrToFloat(dr[1].ToString().Trim(), 0).ToString()); ft = tbStaffInfo.GetStaffInfoModelByName(dr[2].ToString().Trim()); if (ft != null) { mi.StaffID = ft.StaffID; } mi.mIsIncomeExpenditure = 1; mi.mType = -1; mi.mRemark = dr[4].ToString().Trim(); if (tbMarketingFeesInfo.AddMarketingFeesInfo(mi) > 0) { importdata_count++; } } } } } } finally { ds.Clear(); ds.Dispose(); } } catch (Exception ex) { AddErrLine("<b>文件格式错误,请将 Xls 文件用 Excel 另存后再导入!</b>:<br>" + ex); //AddScript("window.setTimeout('history.back(1);',5000);"); } } if (importdata_count > 0) { AddMsgLine("数据导入成功!共导入数据[" + importdata_count.ToString() + "]条."); AddScript("window.setTimeout('window.parent.HidBox();',5000);"); } else { AddErrLine("系统忙!导入失败!"); //AddScript("window.setTimeout('history.back(1);',1000);"); } } finally { mi = null; si = null; ft = null; } } else { AddErrLine("为发现任何数据!导入失败!"); AddScript("window.setTimeout('history.back(1);',1000);"); } } finally { files = null; filearr.Clear(); } } } else { AddErrLine("权限不足!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } else { AddErrLine("请先登录!"); SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); } }