/// <summary>
/// 根据月份统计
/// </summary>
/// <param name="time"></param>
/// <returns></returns>
private DataTable GetData_Month(DateTime time)
{
DataTable dt = new DataTable();
dt.Columns.Add("Count", typeof(int)); //个数
dt.Columns.Add("Date", typeof(string)); //日期
DataRow dr;
try
{
Service.IService.IMobilePhone service = new Service.ServiceImp.MobilePhone();
var firstDay = Convert.ToDateTime(time.Year + "-" + time.Month + "-01");
var lastDay = Convert.ToDateTime(Convert.ToDateTime(time.AddMonths(1).ToString("yyyy-MM-01")).AddDays(-1).ToString("yyyy-MM-dd 23:59"));
var list = service.LoadListAll(p => p.MobileOutTime >= firstDay && p.MobileOutTime < lastDay);
for (int i = 1; i <= DateTime.DaysInMonth(time.Year, time.Month); i++)
{
dr = dt.NewRow();
dr["Date"] = Convert.ToDateTime(time.Year + "-" + time.Month + "-" + i).ToString("yyyy-MM-dd");
dr["Count"] = list.Where(p => p.MobileOutTime >= Convert.ToDateTime(dr["Date"].ToString()) && p.MobileOutTime < Convert.ToDateTime(dr["Date"].ToString() + " 23:59")).ToList().Count;
dt.Rows.Add(dr);
}
}
catch (Exception)
{
throw;
}
return(dt);
}
private void 除ToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID"));
if (DialogResult.OK == XtraMessageBox.Show("您确定将该条记录删除吗？", "操作", MessageBoxButtons.OKCancel))
{
Service.IService.IMobilePhone service = new Service.ServiceImp.MobilePhone();
var model = service.Get(p => p.ID == id);
model.MobileState = 0; //修改出库状态为入库
model.MobileOutTime = null; //修改出库时间
model.MobileSales = null; //出库金额为0
model.MobileSalesPersonId = null; //修改销售员
model.MobileOutRemarks = string.Empty; //修改出库备注为空
model.MobileProfit = null; //利润
if (service.Update(model))
{
XtraMessageBox.Show("删除成功!");
OutStorageManage_Load(null, null);
}
else
{
XtraMessageBox.Show("删除失败!");
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("删除出错!" + ex.Message);
}
}
private void InitDataById(int id)
{
try
{
if (id <= 0)
{
return;
}
Service.IService.IMobilePhone phone = new Service.ServiceImp.MobilePhone();
var model = phone.Get(p => p.ID == id);
lue_Brand.EditValue = model.MobileBrandId; //品牌ID
lue_Type.EditValue = model.MobileModelId; //型号ID
txt_IMEI.Text = model.MobileIMEI; //串码
txt_Cost.Text = model.MobileCost.ToString(); //成本
lue_Supplier.EditValue = model.MobileSupplierId; //供应商
txt_Remarks.Text = model.MobileRemarks; //备注
txt_IntoDate.Text = model.MobileInTime == null?DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") : Convert.ToDateTime(model.MobileInTime).ToString("yyyy/MM/dd HH:mm:ss"); //入库时间
}
catch (Exception ex)
{
XtraMessageBox.Show("根据ID加载数据出错!" + ex.Message);
}
}
private void InitDataById(int id)
{
try
{
Service.IService.IMobilePhone service = new Service.ServiceImp.MobilePhone();
var model = service.Get(p => p.ID == id);
btn_Select.Text = model.MobileIMEI; //串码
lbl_Brand.Text = model.MobileBrand.PROPNAME; //品牌
lbl_Type.Text = model.MobileModel.PROPNAME; //型号
lbl_Supplier.Text = model.MobileSupplier.PROPNAME; //供应商
lbl_Cost.Text = model.MobileCost.ToString(); //成本
txt_Remarks.Text = model.MobileOutRemarks; //备注
lue_SalePerson.EditValue = model.MobileSalesPersonId; //销售员
txt_Sales.Text = model.MobileSales.ToString(); //出库金额
txt_OutDate.Text = model.MobileOutTime == null?DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") : Convert.ToDateTime(model.MobileOutTime).ToString("yyyy/MM/dd HH:mm:ss"); //出库时间
}
catch (Exception ex)
{
XtraMessageBox.Show("加载数据出错!" + ex.Message);
}
}
/// <summary>
/// 根据年份统计
/// </summary>
/// <param name="time"></param>
/// <returns></returns>
private DataTable GetData_Year(DateTime time)
{
DataTable dt = new DataTable();
dt.Columns.Add("Count", typeof(int)); //个数
dt.Columns.Add("Brand", typeof(string)); //品牌
DataRow dr;
try
{
Service.IService.IMobilePhone service = new Service.ServiceImp.MobilePhone();
Service.IService.IPropTypeBase prop = new Service.ServiceImp.PropTypeBase();
var firstMonth = Convert.ToDateTime(time.Year + "-01-01");
var lastMonth = Convert.ToDateTime(Convert.ToDateTime(time.Year + "-12-31").ToString("yyyy-MM-dd 23:59"));
var list = service.LoadListAll(p => p.MobileOutTime >= firstMonth && p.MobileOutTime < lastMonth);
var brand = prop.LoadListAll(p => p.PROPPARENT == 2); //获取所有品牌
foreach (var b in brand)
{
dr = dt.NewRow();
dr["Brand"] = b.PROPNAME;
dr["Count"] = list.Where(p => p.MobileBrandId == b.PROPID).Where(p => p.MobileOutTime >= firstMonth && p.MobileOutTime < lastMonth).ToList().Count;
dt.Rows.Add(dr);
}
}
catch (Exception)
{
throw;
}
return(dt);
}
private void 除ToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID"));
if (DialogResult.OK == XtraMessageBox.Show("您确定将该条记录删除吗？", "操作", MessageBoxButtons.OKCancel))
{
Service.IService.IMobilePhone service = new Service.ServiceImp.MobilePhone();
if (service.Delete(p => p.ID == id) > 0)
{
XtraMessageBox.Show("删除成功!");
IntoStorageManage_Load(null, null);
}
else
{
XtraMessageBox.Show("删除失败!");
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("删除异常!" + ex.Message);
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (SelectId <= 0 || string.IsNullOrEmpty(btn_Select.Text.Trim()))
{
XtraMessageBox.Show("请您选择串号!");
return;
}
if (string.IsNullOrEmpty(lue_SalePerson.Text) || lue_SalePerson.Text == "请选择")
{
XtraMessageBox.Show("请您选择销售员!");
return;
}
if (string.IsNullOrEmpty(txt_Sales.Text.Trim()))
{
XtraMessageBox.Show("请您填写出库金额!");
return;
}
else
{
if (!Common.Tools.IsNumber(txt_Sales.Text.Trim()))
{
XtraMessageBox.Show("出库金额格式不正确!");
return;
}
}
if (string.IsNullOrEmpty(txt_OutDate.Text.Trim()))
{
XtraMessageBox.Show("出库时间不能为空!");
return;
}
else
{
if (!Common.Tools.IsDate(txt_OutDate.Text.Trim()))
{
XtraMessageBox.Show("出库时间格式不正确!");
return;
}
}
Service.IService.IMobilePhone service = new Service.ServiceImp.MobilePhone();
var model = service.Get(p => p.ID == SelectId);
model.MobileSales = Convert.ToDecimal(txt_Sales.Text.Trim()); //出库金额
model.MobileSalesPersonId = Convert.ToInt32(lue_SalePerson.EditValue); //销售员
//如果有出库时间，则不修改出库时间
model.MobileOutTime = Convert.ToDateTime(txt_OutDate.Text.Trim());
model.MobileState = 1;
model.MobileProfit = model.MobileSales - model.MobileCost; //利润
model.MobileOutRemarks = txt_Remarks.Text.Trim(); //备注
if (service.Update(model))
{
DialogResult = DialogResult.OK;
XtraMessageBox.Show("保存成功!");
this.Close();
}
else
{
XtraMessageBox.Show("保存失败!");
}
}
catch (Exception)
{
throw;
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(lue_Brand.Text) || lue_Brand.Text == "请选择")
{
XtraMessageBox.Show("请您选择品牌!");
return;
}
if (string.IsNullOrEmpty(lue_Type.Text) || lue_Type.Text == "请选择")
{
XtraMessageBox.Show("请您选择型号!");
return;
}
if (string.IsNullOrEmpty(lue_Supplier.Text) || lue_Supplier.Text == "请选择")
{
XtraMessageBox.Show("请您选择供应商!");
return;
}
if (string.IsNullOrEmpty(txt_IMEI.Text.Trim()))
{
XtraMessageBox.Show("请您填写串号!");
return;
}
if (string.IsNullOrEmpty(txt_Cost.Text.Trim()))
{
XtraMessageBox.Show("请您填写金额!");
return;
}
else
{
if (!Common.Tools.IsNumber(txt_Cost.Text.Trim()))
{
XtraMessageBox.Show("金额格式不正确!");
return;
}
}
if (string.IsNullOrEmpty(txt_IntoDate.Text.Trim()))
{
XtraMessageBox.Show("入库时间不能为空!");
return;
}
else
{
if (!Common.Tools.IsDate(txt_IntoDate.Text.Trim()))
{
XtraMessageBox.Show("入库时间格式不正确!");
return;
}
}
Service.IService.IMobilePhone phone = new Service.ServiceImp.MobilePhone();
Domain.MobilePhone mobile = new Domain.MobilePhone();
if (Id <= 0)
{
//保存
if (phone.IsExist(p => p.MobileIMEI == txt_IMEI.Text.Trim()))
{
XtraMessageBox.Show("该串码已经存在!");
return;
}
}
else
{
mobile = phone.Get(p => p.ID == Id);
if (mobile.MobileIMEI != txt_IMEI.Text.Trim() && phone.IsExist(p => p.MobileIMEI == txt_IMEI.Text.Trim()))
{
XtraMessageBox.Show("该串码已经存在!");
return;
}
}
mobile.MobileBrandId = Convert.ToInt32(lue_Brand.EditValue); //品牌ID
mobile.MobileModelId = Convert.ToInt32(lue_Type.EditValue); //型号ID
mobile.MobileIMEI = txt_IMEI.Text.Trim(); //串码
mobile.MobileCost = Convert.ToDecimal(txt_Cost.Text.Trim()); //成本
mobile.MobileSupplierId = Convert.ToInt32(lue_Supplier.EditValue); //供应商
mobile.MobileInTime = Convert.ToDateTime(txt_IntoDate.Text.Trim());
mobile.MobileState = 0; //0 表示未出库
mobile.MobileRemarks = txt_Remarks.Text.Trim(); //备注
if (phone.SaveOrUpdate(mobile, Id > 0))
{
XtraMessageBox.Show("保存成功!");
DialogResult = DialogResult.OK;
this.Close();
}
else
{
XtraMessageBox.Show("保存失败!");
}
}
catch (Exception ex)
{
XtraMessageBox.Show("保存失败!" + ex.Message);
}
}
