/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
try
{
var member = new LHCustomerPrice
{
FCode = txtFCode.Text,
FItemCode = txtFItemCode.Text,
FCompanyId = CurrentUser.AccountComId,
FFlag = 1,
FMemo = txtFMemo.Text,
FPrice = Convert.ToDecimal(txtFPrice.Text.Trim()),
FBeginDate = dateBegin.SelectedDate,
FCreateBy = CurrentUser.AccountName,
FCreateDate = DateTime.Now
};
return(CustomerPriceService.Add(member));
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
var errorRow = -1;
try
{
using (var ts = new TransactionScope())
{
var data = ViewState["dtData"] as DataTable;
if (data == null)
{
return;
}
var stringBuilder = new StringBuilder();
for (int i = 0; i < data.Rows.Count; i++)
{
errorRow = i + 1;
var item = new LHCustomerPrice
{
FCode = data.Rows[i]["客户代码"].ToString(),
FItemCode = data.Rows[i]["商品代码"].ToString(),
FPrice = Convert.ToDecimal(data.Rows[i]["发货单价"]),
FCompanyId = CurrentUser.AccountComId,
FBeginDate = Convert.ToDateTime(data.Rows[i]["执行开始时间"]),
FFlag = 1
};
CustomerPriceService.AddEntity(item);
}
//写入数据库
CustomerPriceService.SaveChanges();
ts.Complete();
Alert.Show("引入完成。", MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
Alert.Show(string.Format(@"引入失败，请排查模版内容是否完善，出错定位行：{0} ", errorRow), MessageBoxIcon.Information);
}
}
/// <summary>
/// 提交编辑
/// </summary>
private bool SubmintEdit()
{
if (CustomerPrice != null)
{
var parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@FUpdateBy", CurrentUser.AccountName);
parms.Add("@FId", CustomerPrice.FId);
SqlService.ExecuteProcedureCommand("proc_LHCustomerPriceLog", parms);
CustomerPrice.FPrice = Convert.ToDecimal(txtFPrice.Text.Trim());
CustomerPrice.FMemo = txtFMemo.Text;
CustomerPrice.FItemCode = txtFItemCode.Text;
CustomerPrice.FBeginDate = dateBegin.SelectedDate;
//CustomerPrice.FEndDate = dateEnd.SelectedDate;
CustomerPrice.FUpdateBy = CurrentUser.AccountName;
CustomerPrice.FUpdateDate = DateTime.Now;
CustomerPriceService.SaveChanges();
var priceLog = new LHCustomerPrice_Log();
priceLog.FCode = CustomerPrice.FCode;
priceLog.FCompanyId = CustomerPrice.FCompanyId;
priceLog.FDate = DateTime.Now;
priceLog.FFlag = "变更后";
priceLog.FItemCode = CustomerPrice.FItemCode;
priceLog.FPrice = CustomerPrice.FPrice;
priceLog.FUpdateBy = CurrentUser.AccountName;
priceLog.FUpdateDate = DateTime.Now;
return(CustomerPriceLogService.Add(priceLog));
}
return(false);
}
public static string LoadDataFromExcel1(string filePath, string fileName, string tableName)
{
CustomerPriceService priceservce = new CustomerPriceService();
string Mess = string.Empty;
try
{
if (!tableName.EndsWith("$"))
{
tableName = tableName + "$";
}
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + fileName + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
OleDbConnection OleConn = new OleDbConnection(strConn);
OleConn.Open();
string sql = "SELECT * FROM [" + tableName + "]";
OleDbCommand com = new OleDbCommand(sql, OleConn);
OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);
DataSet ds = new DataSet();
OleDaExcel.Fill(ds, tableName);
OleConn.Close();
int k = 0;
int Datacount = 0;
for (int n = 0; n < ds.Tables.Count; n++)
{
if (ds.Tables[n].Rows.Count < 1)
{
Mess = "没有数据！";
Datacount++;
}
}
for (int j = 0; j < ds.Tables.Count; j++)
{
for (int i = 0; i < ds.Tables[j].Rows.Count; i++)
{
long num = Convert.ToInt64(ds.Tables[j].Rows[i + 1][1]);
string sqlStr = "insert into CustomerSentTB(Rid,CusID,Cid,Destination,Kilo,Price,Resdate,IsSet) values";
sqlStr += " (" + ds.Tables[j].Rows[i + 1][1].ToString() + ","; //面单号
//面单分配
DisNoteManager numdis = new DisNoteManager();
DisNoteTB dnt = new DisNoteTB();
//根据面单号查客户ID和公司ID
dnt = numdis.GetNoteByRid(Convert.ToInt64(ds.Tables[j].Rows[i + 1][1]));
if (dnt.Customer != null)
{
sqlStr += dnt.Customer.CusID + ","; //客户ID
sqlStr += dnt.CarrieCompany.Cid + ",'"; //公司ID
}
else
{
sqlStr += "null" + ",";
sqlStr += "null" + ",'";
}
sqlStr += ds.Tables[j].Rows[i + 1][2].ToString() + "',"; //目的地
double kg = Convert.ToDouble(ds.Tables[j].Rows[i + 1][3]);
if (kg % 1 > 0)
{
kg = kg - kg % 1 + 1;
}
sqlStr += Convert.ToDouble(ds.Tables[j].Rows[i + 1][3]) + ","; //公斤数
if (dnt.Customer != null)
{
CustomerPriceTB tem = new CustomerPriceTB();
tem = priceservce.GetInfoByCusidAndCid(dnt.Customer.CusID, dnt.CarrieCompany.Cid);
PriceTB pt = new PriceTB();
PricesManager pm = new PricesManager();
pt = pm.GetPriceByInfo(tem.PNo, kg, ds.Tables[j].Rows[i + 1][2].ToString());
double price = pt.Price;
sqlStr += price + ",'"; //运费
}
else
{
sqlStr += 0 + ",'"; //运费
}
sqlStr += Convert.ToDateTime(ds.Tables[j].Rows[i + 1][4].ToString().Trim()) + "',"; //揽件时间
sqlStr += 0 + ")";
int row = DBHelper.ExecuteCommand(sqlStr);
k += row;
}
}
Mess = k.ToString();
return(Mess);
}
catch (Exception ex)
{
Mess = "" + ex.Message;
return(Mess);
}
}