销售订单新增时问题
金蝶云社区-赵建成
赵建成
0人赞赏了该文章 860次浏览 未经作者许可,禁止转载编辑于2017年01月05日 11:23:52
选择物料后返回数据后正常情况单据体会自动增加一行,如图,会带出计量单位:


注册表单插件后,选择物料后返回数据后,返回的最后一行不带出计量单位,而且不自动增加一行;点击新增行后会跳行,如图:


代码如下:
public override void DataChanged(DataChangedEventArgs e)
{
switch (e.Field.Key.ToUpper())
{
case "FMATERIALID":
EntryEntity saleorderEntity = this.View.BusinessInfo.GetEntryEntity("FSaleOrderEntry");
DynamicObjectCollection saleorder = this.View.Model.GetEntityDataObject(saleorderEntity);
Hashtable f2 = new Hashtable();
foreach (DynamicObject entityObj in saleorder)
{
DynamicObject rowobj = entityObj;
fmaterialId = Convert.ToInt32(rowobj["MaterialId_ID"]);
fseq = Convert.ToInt32(rowobj["seq"]);
string sql2 = "select a.FMATERIALID,b.fnumber from t_BD_MaterialStock a inner join t_BD_Stock b on a.FSTOCKID=b.FSTOCKID where a.FMATERIALID=@fmaterialId";
SqlParam param2 = new SqlParam("@fmaterialId", KDDbType.Int32, fmaterialId);
using (IDataReader dr = DBUtils.ExecuteReader(this.Context, sql2, param2))
{
while (dr.Read())
{
f2.Add(Convert.ToInt32(dr["fmaterialId"].ToString()), Convert.ToString(dr["fnumber"].ToString()));
rowobj["FStock"] = f2[fmaterialId];
}
}
}
this.View.UpdateView("FSaleOrderEntry");
break;
}
}