import clr
clr.AddReference('Kingdee.BOS.App')
from Kingdee.BOS.App.Data import *

def BarItemClick(e):
    if e.BarItemKey=="Gold_UPdate":
        # UPDATE更新生产订单合格率、完工率
        sql = "/*dialect*/UPDATE T_PRD_MOENTRY SET T_PRD_MOENTRY.F_GOLD_COMP = Gold_V_HGL.PCOMP,T_PRD_MOENTRY.F_Gold_Qua = Gold_V_HGL.PQua FROM T_PRD_MOENTRY INNER JOIN Gold_V_HGL ON T_PRD_MOENTRY.FENTRYID = Gold_V_HGL.ENTRYID WHERE T_PRD_MOENTRY.fid>128928";
        count = DBUtils.Execute(this.Context,sql);
        this.View.ShowMessage("更新成功，受影响行数："+count.ToString());
        this.View.Refresh();
    elif e.BarItemKey=="Gold_Select":
        # SELECT查询当前登录用户信息
        sql = "SELECT FNAME FROM T_SEC_USER WHERE FUSERID="+this.Context.UserId.ToString();
        userName = DBUtils.ExecuteScalar(this.Context,sql,None);
        this.View.ShowMessage(userName);