/// <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()));
}
}
