internal bool ReadList(out List <RawMaterialsDetailModel> data)
{
bool flag = true;
data = new List <RawMaterialsDetailModel>();
string sql = "select b.Number as Code,b.Name as Name,total(a.Number) as Amount from T_Warehouse_RawMaterials a left join T_ProductInfo_RawMaterials b on a.RawMaterialsID = b.GUID group by a.RawMaterialsID";
DataSet ds = new DataSet();
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
int id = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
RawMaterialsDetailModel d = new RawMaterialsDetailModel();
d.Id = id;
id++;
d.Code = dr["Code"].ToString();
d.Name = dr["Name"].ToString();
d.Amount = dr["Amount"].ToString();
data.Add(d);
}
}
return(flag);
}
/// <summary>
/// Lugia
/// 获取原料信息
/// </summary>
/// <param name="Number"></param>
/// <returns></returns>
internal RawMaterialsDetailModel GetRawMaterialsInfo(string Number)
{
RawMaterialsDetailModel m = new RawMaterialsDetailModel();
string sql = "Select Guid,Name From T_ProductInfo_RawMaterials Where Number='" + Number + "' AND DeleteMark ISNULL";
DataSet ds = new DataSet();
if (new Helper.SQLite.DBHelper().QueryData(sql, out ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
m.RawMaterialsID = (Guid)dr["Guid"];
m.Name = dr["Name"].ToString();
}
}
return(m);
}
public Page_Warehouse_RawMaterials()
{
InitializeComponent();
data = new List <RawMaterialsDetailModel>();
for (int i = 0; i < 18; i++)
{
RawMaterialsDetailModel m = new RawMaterialsDetailModel();
m.Id = i + 1;
m.Date = DateTime.Now.ToString("yyyy.MM.dd");
m.Operator = Helper.DataDefinition.CommonParameters.RealName;
m.RawMaterialsID = new Guid();
m.Type = "入库";
data.Add(m);
}
DataGrid_RawMaterials.ItemsSource = data;
}
private void DataGrid_RawMaterialsQuantity_LoadingRow(object sender, DataGridRowEventArgs e)
{
e.Row.MouseRightButtonDown += (s, a) =>
{
a.Handled = true;
(sender as DataGrid).SelectedIndex = (s as DataGridRow).GetIndex();
(s as DataGridRow).Focus();
RawMaterialsDetailModel d = this.DataGrid_RawMaterialsQuantity.SelectedCells[0].Item as RawMaterialsDetailModel;
//show Packing Grid
this.Label_ShowWarnMessage.Content = "";
this.Grid_OutGrid.Visibility = System.Windows.Visibility.Visible;
int count = 0;
int.TryParse(d.Amount, out count);
PackStock = count;
PCode = d.Code;
this.TextBox_Quantity_OutGrid.Focus();
this.Label_RawMaterialsName.Content = d.Name;
};
}
internal bool ReadRecordList(string Type, out List <RawMaterialsDetailModel> data)
{
string sql_Where = "";
if (!Type.StartsWith("全部"))
{
sql_Where += " Where a.Type='" + Type + "' ";
}
bool flag = true;
data = new List <RawMaterialsDetailModel>();
string sql = " select a.Guid as Guid,a.RawMaterialsID as RawMaterialsID,b.Name as Name,strftime(a.Date) as Date,a.Operator as Operator,a.Number as Number,a.Remark as Remark,a.Type as Type "
+ " from T_Warehouse_RawMaterials a "
+ " left join T_ProductInfo_RawMaterials b on a.RawMaterialsID = b.Guid "
+ sql_Where
+ " order by a.Date desc ";
DataSet ds = new DataSet();
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
int id = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
RawMaterialsDetailModel d = new RawMaterialsDetailModel();
d.Id = id;
id++;
d.Guid = Guid.Parse(dr["Guid"].ToString());
d.RawMaterialsID = Guid.Parse(dr["RawMaterialsID"].ToString());
d.Date = dr["Date"].ToString();
decimal dd = 0;
decimal.TryParse(dr["Number"].ToString(), out dd);
d.Number = dd;
d.Name = dr["Name"].ToString();
d.Remark = dr["Remark"].ToString();
d.Operator = dr["Operator"].ToString();
d.Type = dr["Type"].ToString();
data.Add(d);
}
}
return(flag);
}
private void Button_OutGrid_Click(object sender, RoutedEventArgs e)
{
List <RawMaterialsDetailModel> list = new List <RawMaterialsDetailModel>();
RawMaterialsDetailModel m = new RawMaterialsDetailModel();
m.RawMaterialsID = rmc.GetGuid(PCode);
m.Type = RadioButton_生产.IsChecked == true ? "生产" : "出库";
m.Date = DateTime.Now.ToString();
int Number = 0;
int.TryParse(this.TextBox_Quantity_OutGrid.Text, out Number);
m.Number = Number;
m.Operator = Helper.DataDefinition.CommonParameters.RealName;
list.Add(m);
if (rmc.AddByBatch(list, false))
{
InitializeRawMaterialsDataGrid();
this.Grid_OutGrid.Visibility = System.Windows.Visibility.Collapsed;
}
}
private void DataGrid_RawMaterials_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
RawMaterialsDetailModel model = this.DataGrid_RawMaterials.SelectedCells[0].Item as RawMaterialsDetailModel;
string newValue = (e.EditingElement as TextBox).Text;
string HeaderStr = e.Column.Header.ToString();
if (HeaderStr.Equals("原材料编号"))
{
RawMaterialsDetailModel m = vmc.GetRawMaterialsInfo(newValue);
if (m.RawMaterialsID != new Guid())
{
data[data.IndexOf(model)].RawMaterialsID = m.RawMaterialsID;
data[data.IndexOf(model)].Code = newValue;
data[data.IndexOf(model)].Name = m.Name;
}
else
{
data[data.IndexOf(model)].RawMaterialsID = new Guid();
data[data.IndexOf(model)].Code = newValue;
data[data.IndexOf(model)].Name = "";
DataGrid_RawMaterials.CurrentCell = new DataGridCellInfo(DataGrid_RawMaterials.SelectedCells[0].Item, DataGrid_RawMaterials.Columns[1]);
}
}
}
